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
Imported from BI Publisher
SQL 23 lines
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 |
Parameters 6
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |