PAY IRP5 Tax Certificates

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

    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
Download
 
Related Blitz Reports
PAY SuperStream Combined Report Alternative Format (ALL FUNDS) PAY RTI FPS Run Reconciliation PAY RTI - Full Payment Submission Output 2014/15 PAY RTI - Full Payment Submission Output 2016/17 PAY RTI - Full Payment Submission Output 2017/18 PAY RTI - Full Payment Submission Output 2013/14 PAY RTI - Full Payment Submission Output 2015/16 PAY SuperStream Combined Report Alternative Format PAY RTI - Year End P60 Report Process (Multi Threaded) PAY RTI - Year End P60 Report Process
Blitz Report™

Blitz Report™ provides multiple benefits: