PAY Employment Tax Incentive Register

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
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
Download
Related Blitz Reports
PAY Payroll Reconciliation Detail PAY P46 EDI Process v6 Output PQP Generate MCR CSV PAY P46EXP EDI Process v6 Output PAY GB Pensions Automatic Enrollment not applied PAY Payroll Tax Report by Legal Employer PAY GB BIK Audit PAY RTI - Earlier Year Update Output 2014/15 PQP Teachers Pension MCR Reconciliation Report (Excel) PAY RTI ? Employer Alignment Submission Output
Blitz Report™

Blitz Report™ provides multiple benefits: