ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717B51A9E05362FB09050512Y SELECT DISTINCT htuv.name GRE_Name , ppf.national_identifier Social_Insurance_Number , ppf.hire_date Hire_Date , to_number(ppf.employee_number) Employee_ID , htuv.employer_identification_number Business_Number , to_char(ppf.hire_date, 'DD/MM/YY') Hire_Date_tobe_printed FROM per_people_v ppf , hr_ca_tax_units_v htuv , hr_soft_coding_keyflex hskf , per_assignments_f paf , per_person_types ppt WHERE ppf.business_group_id+0 = nvl(:P_BUSINESS_GROUP_ID, ppf.business_group_id) AND paf.soft_coding_keyflex_id = hskf.soft_coding_keyflex_id AND paf.person_id = ppf.person_id AND hskf.segment1 = to_char(htuv.tax_unit_id) AND htuv.tax_unit_id = nvl(:P_TAX_UNIT_ID, htuv.tax_unit_id) AND htuv.reporting_type = 'T4/RL1' AND ppt.person_type_id = ppf.person_type_id AND ppt.system_person_type in ('EMP', 'EMP_APL') AND ppf.hire_date BETWEEN :P_STARTING_HIRED_DATE and :P_ENDING_HIRED_DATE ORDER BY &P_SORT_TAG PER PERCACEI_XML US PER Report on Hirings Imported from BI Publisher Application: Human Resources Source: Report on Hirings (XML) Short Name: PERCACEI_XML DB package: PER_PERCACEI_XMLP_PKG BI Publisher &p_sort_tag :col1 :col2 :cp_consolidation :cp_gre :cp_payroll_name :cp_report_title :p_business_group_id :p_conc_request_id :p_consolidation_set_id :p_ending_hired_date :p_payroll_id :p_sort1 :p_sort2 :p_sort3 :p_sort_count :p_sort_tag :p_starting_hired_date :p_tax_unit_id 1 -50 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group Name 2 -40 :p_not_consolidation_set_id Char SELECT decode (nvl(:$FLEX$.Consolidation_Set_ID:NULL,0),0,'X',NULL) FROM DUAL US Not_Consolidation_Set_ID 3 -30 :p_not_payroll_id Char SELECT decode(nvl(:$FLEX$.Payroll_ID:NULL,0),0,'X',NULL) FROM DUAL US Not_Payroll_ID 4 -20 :p_not_payroll_action_id Char SELECT decode(nvl(:$flex$.payroll_run:NULL,0),0,'X',NULL) FROM DUAL US Not Payroll Action ID 5 10 :p_starting_hired_date Date Y US Starting Hire Date 6 20 :p_ending_hired_date Date Y US Ending Hire Date 7 30 :p_tax_unit_id LOV Oracle HR_CA_T4_TAX_UNIT_NAME Y select hov.organization_id id, hov.name value, null description from hr_all_organization_units_vl hov,hr_organization_information hoi,hr_organization_information o3 where hov.business_group_id=fnd_global.per_business_group_id and hoi.org_information5='T4/RL1' and hov.organization_id=hoi.organization_id and o3.org_information_context='CLASS' and o3.org_information1='HR_LEGAL' and hov.organization_id=o3.organization_id and o3.org_information2='Y' and exists (select 'x' from fnd_sessions fnd where userenv('sessionid')=fnd.session_id and fnd.effective_date between hov.date_from and nvl(hov.date_to,to_date('31-12-4712','DD-MM-YYYY')) ) order by value,description US Government Reporting Entity 8 40 :p_sort1 LOV Oracle PER_CEIC_SORT_OPTION_ONE Y select hlu.meaning id, hlu.meaning value, null description from hr_lookups hlu where hlu.lookup_type='PER_CEIC_SORT' order by value,description select lku.meaning from hr_lookups lku WHERE lku.lookup_type = 'PER_CEIC_SORT' AND lku.application_id = '800' AND lku.lookup_code = '01' US Sort Option One 9 50 :p_sort2 LOV Oracle PER_CEIC_SORT_OPTION_TWO Y select hlu.meaning id, hlu.meaning value, null description from hr_lookups hlu where hlu.lookup_type='PER_CEIC_SORT' and hlu.meaning<>:$flex$.per_ceic_sort_option_one order by value,description select lku.meaning from hr_lookups lku WHERE lku.lookup_type = 'PER_CEIC_SORT' AND lku.application_id = '800' AND lku.lookup_code = '02' US Sort Option Two 10 60 :p_sort3 LOV Oracle PER_CEIC_SORT_OPTION_THREE Y select hlu.meaning id, hlu.meaning value, null description from hr_lookups hlu where hlu.lookup_type='PER_CEIC_SORT' and hlu.meaning<>:$flex$.per_ceic_sort_option_one and hlu.meaning<>:$flex$.per_ceic_sort_option_two order by value,description US Sort Option Three