ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4716F51A9E05362FB09050512 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 Y PAY PYZAETIR US PAY Employment Tax Incentive Register Imported from BI Publisher Application: Payroll Source: Employment Tax Incentive Register Report Short Name: PYZAETIR DB package: PAY_ZA_ETI BI Publisher :p_legal_entity_id :p_payroll_action_id 1 -10 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group ID Business Group ID 2 10 :p_legal_entity_id LOV Oracle PER_ZA_LEGAL_ENTITY Y select haou.organization_id id, haou.name value, null description from fnd_sessions fss,hr_all_organization_units haou,hr_organization_information hoi,hr_organization_information hoi2 where fss.session_id=userenv('sessionid') and fss.effective_date between haou.date_from and nvl(haou.date_to,to_date('31-12-4712','DD-MM-YYYY')) and haou.business_group_id=fnd_global.per_business_group_id and hoi.organization_id=haou.organization_id and hoi.org_information_context='ZA_LEGAL_ENTITY' and hoi2.organization_id=haou.organization_id and hoi2.org_information_context='CLASS' and hoi2.org_information1='HR_LEGAL' and hoi2.org_information2='Y' order by haou.name Y US Legal Entity Legal Entity 3 20 :p_payroll_action_id LOV Oracle PY_ZA_ETI_PREPROCESS Y select ppa.payroll_action_id id, to_char(ppa.effective_date,'DD-MON-YYYY') || '(' || to_char(ppa.payroll_action_id)||')' value, null description from pay_payroll_actions ppa where ppa.business_group_id+0=fnd_global.per_business_group_id and ppa.action_type='X' and ppa.report_type='PYZAETIA' and ppa.action_status='C' and pay_za_eti.get_parameters(ppa.legislative_parameters,'LEGAL_ENTITY_ID')=:$flex$.per_za_legal_entity order by ppa.request_id desc Y US Employment Tax Incentive Archiver ETI Register Report Preprocess :$flex$.per_za_legal_entity Legal Entity Employment Tax Incentive Archiver