View: PAY_EMEA_TAX_DET_ACTION_INFO_V

Product:	PAY - Payroll
Description:	Used to support online payslip
Implementation/DBA Data:	APPS.PAY_EMEA_TAX_DET_ACTION_INFO_V

View Text

SELECT LCK.LOCKING_ACTION_ID
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PAI.ACTION_INFORMATION6
FROM PAY_ACTION_INFORMATION PAI
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAA1.PAYROLL_ACTION_ID = PAI.ACTION_INFORMATION1
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAI.ACTION_CONTEXT_TYPE = 'PA'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA PAYROLL INFO'

Columns