PAY Employment Tax Incentive Register
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: Employment Tax Incentive Register Report
Short Name: PYZAETIR
DB package: PAY_ZA_ETI
Application: Payroll
Source: Employment Tax Incentive Register Report
Short Name: PYZAETIR
DB package: PAY_ZA_ETI
Run
PAY Employment Tax Incentive Register and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT DISTINCT pai.action_information1 full_name ,pai.action_information2 employee_number ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai.action_information3)) date_of_birth ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai.action_information4)) employment_comm_date ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai.action_information5)) employment_end_date ,pai.action_information6 assignment_number ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai.action_information7)) assignment_start_date ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai.action_information8)) assignment_end_date ,pai.action_information9 tax_reference_number ,pai.action_information10 nature_of_per ,pai.action_information11 identity_number ,pai.action_information12 passport_number ,pai.action_information13 sic_code ,pai.action_information14 sez_code ,pai.action_information15 cmpy_tax_reference_no ,trim(to_char(fnd_number.canonical_to_number(pai.action_information16),'FM99999999990D00')) ETIable_EMP_TOTAL ,trim(to_char(fnd_number.canonical_to_number(pai.action_information17),'FM99999999990D00')) min_wage_emp_total ,trim(to_char(fnd_number.canonical_to_number(pai.action_information18),'FM99999999990D00')) ETI_emp_total ,trim(to_char(fnd_number.canonical_to_number(pai.action_information20),'FM99999999990D00')) ETI_hrs_total ,pai.action_information19 have_refugee_id ,paa.assignment_action_id assignment_action_id ,trim(to_char(fnd_number.canonical_to_number(pai.action_information21),'FM99999999990D99')) ACT_WAGE_EMP_TOTAL FROM pay_action_information pai ,pay_assignment_actions paa WHERE pai.action_context_id = paa.assignment_action_id AND paa.payroll_action_id = :P_PAYROLL_ACTION_ID AND pai.action_context_type = 'AAP' AND pai.action_information_category = 'ZA_ETI_EMPLOYEE_DETAILS' order by full_name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Legal Entity |
|
LOV Oracle | |
Employment Tax Incentive Archiver |
|
LOV Oracle |