VIEW: APPS.PAY_NL_TAXOFF_ACTION_INFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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