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 |
