ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717351A9E05362FB09050512 select pai.action_information3 LINE_NUM, pai.action_information4 CERT_NUM, pai.action_information5 SURNAME, pai.action_information6 FIRST_NAME, pai.action_information7 INITIALS, pai.action_information8 ID_NUM, pai.action_information9 PASSPORT_NUM, pai.action_information10 COUNTRY_OF_ISSUE, pai.action_information11 DOB, pai.action_information12 TAX_REF_NUM, pai.action_information13 EMP_NUM, pai.action_information14 STATUS, pai.action_information15 RESULT, pai.action_information16 ERROR_MSG, pai.action_information17 OLD_TAX_REF_NUM from pay_action_information pai where pai.action_context_type = 'PA' and pai.action_information_category = 'ZA_ITREF_UPLOAD' and pai.action_context_id = &G_PAYROLL_ACTION_ID Y PAY PYZAITREFU US PAY Income Tax Ref No Bulk Upload Imported from BI Publisher Application: Payroll Source: Income Tax Ref No Bulk Upload Short Name: PYZAITREFU DB package: PY_ZA_ITREF_UPLOAD BI Publisher &g_payroll_action_id :cp_bg_name :cp_le_name :cp_paye_num :cp_tot_rec :g_payroll_action_id :p_business_group_id :p_effective_date :p_file_name :p_mode 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group ID Business Group ID 2 10 :p_mode LOV Oracle PY_ZA_ITREF_UPLOAD_MODE Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1026060 order by ffvv.flex_value Y US Mode Mode 3 20 :p_effective_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id =userenv('SESSIONID') Y US Effective Date Effective Date 4 30 :p_file_name Char Y US SARS File Name SARS CSV File