ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4716851A9E05362FB09050512 SELECT paa.assignment_action_id ASG_ACTION_ID ,pai.ACTION_INFORMATION1 asg_no ,pai.ACTION_INFORMATION2 emp_start_date ,pai.ACTION_INFORMATION3 emp_end_date ,pai.ACTION_INFORMATION4 emp_ird_no ,pai.ACTION_INFORMATION5 emp_name ,pai.ACTION_INFORMATION6 email ,pai.ACTION_INFORMATION7 kiwisaver_status 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 = 'NZ_PED_ARCHIVE_ASG_DETAILS' AND pai.ACTION_INFORMATION9 is null Y PAY PYNZED_XML US PAY NZ Generate ED Payday File Imported from BI Publisher Application: Payroll Source: NZ Generate ED Payday File Short Name: PYNZED_XML DB package: BI Publisher :p_payroll_action_id 1 10 :p_legal_emp_id LOV Oracle HR_NZ_REGISTERED_EMPLOYER Y select tu.tax_unit_id id, substr(tu.name,1,150) value, null description from hr_nz_tax_unit_v tu where tu.business_group_id=fnd_global.per_business_group_id order by tu.name US P_LEGAL_EMP_ID Legal Employer 2 20 :p_payroll_action_id LOV Oracle PY_NZ_PED_ARCHIVE_ID Y select ppa.payroll_action_id id, ppa.payroll_action_id value, null description from pay_payroll_actions ppa where pay_core_utils.get_parameter('BG',ppa.legislative_parameters)=fnd_global.per_business_group_id and pay_core_utils.get_parameter('LE',ppa.legislative_parameters)=:$flex$.p_legal_emp_id and ppa.action_type='X' and ppa.action_status='C' and ppa.report_type='NZ_PED_ARCHIVE' and ppa.report_qualifier='NZ' and ppa.report_category='REPORT' order by ppa.effective_date desc,ppa.payroll_action_id desc US Archive ID Archive ID :$flex$.p_legal_emp_id P_LEGAL_EMP_ID Archive ID