PAY Income Tax Ref No Bulk Upload
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: Income Tax Ref No Bulk Upload
Short Name: PYZAITREFU
DB package: PY_ZA_ITREF_UPLOAD
Application: Payroll
Source: Income Tax Ref No Bulk Upload
Short Name: PYZAITREFU
DB package: PY_ZA_ITREF_UPLOAD
Run
PAY Income Tax Ref No Bulk Upload and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Mode |
|
LOV Oracle | |
Effective Date |
|
Date | |
SARS File Name |
|
Char |