PER Report on Hirings

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Human Resources
Source: Report on Hirings (XML)
Short Name: PERCACEI_XML
DB package: PER_PERCACEI_XMLP_PKG
Run PER Report on Hirings and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
PAY Inland Revenue Form IR21 (Singapore) PER ADA (1) PER ADA PER New Hire State PER New Hire State Magnetic Media BEN Participation Audit Log PER Norwegian Child/Child Minder Sickness Leave Warnings BEN Back-out Life Events Summary BEN Back-out Life Events Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: