PER Report on Hirings

Description
Categories: BI Publisher
Application: Human Resources
Source: Report on Hirings (XML)
Short Name: PERCACEI_XML
DB package: PER_PERCACEI_XMLP_PKG
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
Parameter Name SQL text Validation
Starting Hire Date
 
Date
Ending Hire Date
 
Date
Government Reporting Entity
 
LOV Oracle
Sort Option One
 
LOV Oracle
Sort Option Two
 
LOV Oracle
Sort Option Three
 
LOV Oracle
Business Group Name
 
Number
Not_Consolidation_Set_ID
 
Not_Payroll_ID
 
Not Payroll Action ID