PAY IRP5 Tax Certificates
Description
Categories: BI Publisher
Imported from BI Publisher
Description: IRP5 Certificates Process
Application: Payroll
Source: IRP5 Tax Certificates
Short Name: PYZAIRP5_XML
DB package: PAY_ZA_IRP5_IT3A_XMLP_PKG
Description: IRP5 Certificates Process
Application: Payroll
Source: IRP5 Tax Certificates
Short Name: PYZAIRP5_XML
DB package: PAY_ZA_IRP5_IT3A_XMLP_PKG
Run
PAY IRP5 Tax Certificates and other Oracle EBS reports with Blitz Report™ on our demo environment
select pai.action_information2 EMP_EMAIL, pai.action_information3 HOME_PHONE, pai.action_information4 BUS_PHONE, pai.action_information5 FAX_NUMBER, pai.action_information6 CELL_NUMBER, pai.action_information7 BUS_UNIT_NUMBER, pai.action_information8 BUS_COMPLEX, pai.action_information9 BUS_STREET_NUM, pai.action_information10 BUS_FORM, pai.action_information11 BUS_SUBURB, pai.action_information12 BUS_CITY, trim(substr(pai.action_information13,1,10)) BUS_POSTAL_CODE, trim(substr(pai.action_information13,11)) BUS_COUNTRY_CODE, pai.action_information14 RES_UNIT_NUMBER, pai.action_information15 RES_COMPLEX, pai.action_information16 RES_STREET_NUM, pai.action_information17 RES_FORM, pai.action_information18 RES_SUBURB, pai.action_information19 RES_CITY, trim(substr(pai.action_information20,1,10)) RES_POSTAL_CODE, trim(substr(pai.action_information20,11)) RES_COUNTRY_CODE, decode(substr(pai.action_information21,1,1),'X','X',null) POS_RES_ADD_SAME, decode(nvl(substr(pai.action_information21,1,1),'X'),'X',null,'2','Y','N') POS_STR_ADD, decode(substr(pai.action_information21,1,1),'3','X',null) POS_POB_ADD, decode(substr(pai.action_information21,1,1),'4','X',null) POS_PB_ADD, decode(substr(pai.action_information21,2,1),'Y','Y','N') POS_CO_ADD, substr(pai.action_information21,3) POS_CARE_INTER_ADD, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',pai.action_information22,null) POS_LINE1, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',pai.action_information23,null) POS_LINE2, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information24,1,35)),null) POS_LINE3, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information24,36)),null) POS_LINE4, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information25,1,10)),null) POS_CODE, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information25,11)),null) POS_COUN_CODE, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information22,14,8)), null) PSA_UN, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information22,33,26)), null) PSA_CO, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information23,16,8)), null) PSA_SN, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information23,50,26)), null) PSA_SNF, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information24,21,33)), null) PSA_SD, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information24,70,21)), null) PSA_CT, decode(substr(pai.action_information21,1,1),'2',substr(pai.action_information25,1,10),null) PSA_PC, decode(substr(pai.action_information21,1,1),'2',substr(pai.action_information25,11),null) PSA_CC, decode(substr(pai.action_information21,1,1),'X','1','1','4','2','3','2') P_3288, decode(substr(pai.action_information21,1,1),'3','PO_BOX','4','PRIVATE_BAG',null) P_3249, decode(substr(pai.action_information21,1,1),'5',trim(substr(pai.action_information22,27,21)), null) P_3280, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information22,28,length(pai.action_information22))),'4',trim(substr(pai.action_information22,28,length(pai.action_information22))),'5',trim(substr(pai.action_information22,77,21)), null) P_3251, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information23,16,length(pai.action_information23))),'4',trim(substr(pai.action_information23,21,length(pai.action_information23))),'5',trim(substr(pai.action_information23,25,length(pai.action_information23))),null) P_3262, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information24,26,length(pai.action_information24))),'4',trim(substr(pai.action_information24,26,length(pai.action_information24))),'5',trim(substr(pai.action_information24,26,length(pai.action_information24))),null) P_3253, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information25,1,10)),'4',trim(substr(pai.action_information25,1,10)),'5',trim(substr(pai.action_information25,1,10)),null) P_3254, decode(substr(pai.action_information21,1,1),'3',substr(pai.action_information25,11),'4',substr(pai.action_information25,11),'5',substr(pai.action_information25,11),null) P_3286 from pay_action_information pai where pai.action_context_id = :ACTION_CONTEXT_ID and pai.action_context_type = 'AAP' and pai.action_information_category = 'ZATYE_EMPLOYEE_CONTACT_INFO' and pai.action_information30 = :TEMP_CERTIFICATE_NUMBER |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Legal Entity |
|
LOV Oracle | |
| PAY_ZA_TAX_YEAR |
|
Number | |
| Period of Reconciliation |
|
LOV Oracle | |
| Payroll |
|
LOV Oracle | |
| Tax Certificate Preprocess |
|
LOV Oracle | |
| Assignment Number |
|
LOV Oracle | |
| Dummy Run |
|
LOV Oracle | |
| Reissue IRP5 |
|
LOV Oracle | |
| Sort Order 1 |
|
LOV Oracle | |
| Sort Order 2 |
|
LOV Oracle | |
| Sort Order 3 |
|
LOV Oracle | |
| Sort Order 4 |
|
LOV Oracle | |
| Sort Order 5 |
|
LOV Oracle |
