PAY Income Tax Ref No Bulk Upload

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

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_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
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: