PAY IT3A Tax Certificates

Description
Categories: BI Publisher
Columns: Emp Email, Home Phone, Bus Phone, Fax Number, Cell Number, Bus Unit Number, Bus Complex, Bus Street Num, Bus Form, Bus Suburb ...
Application: Payroll
Source: IT3A Tax Certificates
Short Name: PYZAIT3A_XML
DB package: PAY_ZA_IRP5_IT3A_XMLP_PKG
    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,
	      pay_assignment_actions paa
    where pai.action_context_id = paa.assignment_action_id
	  and pai.action_context_type = 'AAP'
	  and pai.action_information_category = 'ZATYE_EMPLOYEE_CONTACT_INFO'
	  and pai.action_information30 = :TEMP_CERTIFICATE_NUMBER
      &C_PAYROLL_ACTION_ID
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 IT3A Tax Certificate
 
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
PY_ZA_CHAR_10
 
Business Group ID
 
Number