ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717C51A9E05362FB09050512Y SELECT meaning "f4_p_naic", decode(segment4,'FR','Fulltime Regular' ,'PR', 'Part-time Regular' ,'PT' , 'Temporary') "f4_p_emp_cat", context || decode(segment4,'FR','A', 'PR','B', 'PT','C') "f4_p_type", segment2 "f4_p_name", decode(context,'FORM4','HIRED' ,'FORM5','PROMOTED' ,'FORM6','TERMINATED') "f4_p_fname", segment3 "f4_p_eeog", nvl(to_number(segment5),0) "f4_p_total", nvl(to_number(segment6),0) "f4_p_totfe", nvl(to_number(segment7),0) "f4_p_totma", nvl(to_number(segment8),0) "f4_p_totab", nvl(to_number(segment9),0) "f4_p_feab", nvl(to_number(segment10 ),0) "f4_p_maab", nvl(to_number(segment11),0) "f4_p_totvi", nvl(to_number(segment12 ),0) "f4_p_fevi", nvl(to_number(segment13),0) "f4_p_mavi", nvl(to_number(segment14),0) "f4_p_totdi", nvl(to_number(segment15),0) "f4_p_fedi", nvl(to_number(segment16),0) "f4_p_madi", PER_PERCAEER_XMLP_PKG.cf_f5_p_totalformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_total, PER_PERCAEER_XMLP_PKG.cf_f5_p_totmaformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_totma, PER_PERCAEER_XMLP_PKG.cf_f5_p_totfeformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_totfe, PER_PERCAEER_XMLP_PKG.cf_f5_p_totabformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_totab, PER_PERCAEER_XMLP_PKG.cf_f5_p_maabformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_maab, PER_PERCAEER_XMLP_PKG.cf_f5_p_feabformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_feab, PER_PERCAEER_XMLP_PKG.cf_f5_p_totdiformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_totdi, PER_PERCAEER_XMLP_PKG.cf_f5_p_madiformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_madi, PER_PERCAEER_XMLP_PKG.cf_f5_p_fediformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_fedi, PER_PERCAEER_XMLP_PKG.cf_f5_p_totviformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_totvi, PER_PERCAEER_XMLP_PKG.cf_f5_p_maviformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_mavi, PER_PERCAEER_XMLP_PKG.cf_f5_p_feviformula(context || decode ( segment4 , 'FR' , 'A' , 'PR' , 'B' , 'PT' , 'C' ), segment2) CF_f5_p_fevi, PER_PERCAEER_XMLP_PKG.cf_f5_p_promptformula() CF_f5_p_prompt from per_ca_ee_report_lines pcer1, hr_lookups where request_id=:p_conc_request_id and context in ('FORM4','FORM5','FORM6') and segment1 ='PROVINCE' and segment20='Y' and lookup_type = 'NAIC' and lookup_code = segment21 and exists ( select pcer2.segment4 from per_ca_ee_report_lines pcer2 where pcer2.request_id = pcer1.request_id and pcer2.context = 'FORM14' and pcer2.segment1 = pcer1.segment1 and pcer2.segment2 = pcer1.segment2 and pcer2.segment3 <> '0' and pcer2.segment4 = 'Y' ) order by 1,4,3 PER PERCAEER_XML US PER Employment Equity Imported from BI Publisher Description: Employment Equity Report Application: Human Resources Source: Employment Equity Report (XML) Short Name: PERCAEER_XML DB package: PER_PERCAEER_XMLP_PKG BI Publisher :c_business_group_name :c_report_subtitle :p_business_group_id :p_conc_request_id :p_date_all_emp :p_date_tmp_emp :p_naic_code :p_report_title :p_session_date :p_session_date1 :p_year 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Id Business Group Id 2 10 :p_year Char Y US Year Year 3 20 :p_naic_code LOV Oracle PER_CA_EE_NAIC Y select hl.lookup_code id, hl.lookup_code value, hl.meaning description from hr_lookups hl where hl.lookup_type='CA_NAIC' and ( (hl.lookup_code in ( select hoi.org_information8 from hr_organization_information hoi, hr_organization_units hou where hoi.organization_id=hou.organization_id and hoi.org_information_context='Canada Employer Identification' and hou.business_group_id=fnd_global.per_business_group_id and hoi.org_information8 is not null) ) or (hl.lookup_code in (select hsck.segment6 from hr_soft_coding_keyflex hsck, per_assignments_f paf where hsck.soft_coding_keyflex_id=paf.soft_coding_keyflex_id and paf.business_group_id=fnd_global.per_business_group_id and hsck.segment6 is not null ) ) ) order by value,description US NAIC Code NAIC Code 4 30 :p_date_all_emp Date Y US Peak Period Date Date(All) 5 40 :p_date_tmp_emp Date Y US Peak Period Date (Temp.) Date(Tmp)