PAY Income Tax Ref No Bulk Upload

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: Income Tax Ref No Bulk Upload
Short Name: PYZAITREFU
DB package: PY_ZA_ITREF_UPLOAD
   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
Business Group ID
 
Number
SARS File Name
 
Effective Date
 
Date
Mode
 
LOV Oracle