View: PAY_NL_TAXOFF_ACTION_INFO_V

Product:	PAY - Payroll
Description:	View Used in Dutch Payslip Report
Implementation/DBA Data:	APPS.PAY_NL_TAXOFF_ACTION_INFO_V

View Text

SELECT PAI_NL_OED.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI_EPI.ACTION_INFORMATION4 TAX_OFFICE_NAME
, PAI_EPI.ACTION_INFORMATION6 TAX_REG_NUMBER
FROM PAY_ACTION_INFORMATION PAI_EPI /* AIC ---- EMEA PAYROLL INFO */
, PAY_ACTION_INFORMATION PAI_NL_OED /* AIC ---- NL OTHER EMPLOYEE DETAILS */
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAA.PAYROLL_ACTION_ID = PAI_EPI.ACTION_CONTEXT_ID /* AIC ---- EMEA PAYROLL INFO */
AND PAI_EPI.ACTION_CONTEXT_TYPE = 'PA'
AND PAI_EPI.ACTION_INFORMATION_CATEGORY = 'EMEA PAYROLL INFO' /* AIC ---- NL OTHER EMPLOYEE DETAILS*/
AND PAA.ASSIGNMENT_ACTION_ID = PAI_NL_OED.ACTION_CONTEXT_ID
AND PAI_NL_OED.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_NL_OED.ACTION_INFORMATION_CATEGORY = 'NL OTHER EMPLOYEE DETAILS'
AND PAI_NL_OED.ACTION_INFORMATION5 = PAI_EPI.ACTION_INFORMATION2

Columns