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
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