View: PAY_IE_EMEA_BAL_V

Product:	PAY - Payroll
Description:	Used in IE Payslip Advice Report
Implementation/DBA Data:	APPS.PAY_IE_EMEA_BAL_V

View Text

SELECT PAI2.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI1.ACTION_INFORMATION4
, 1
, 30) BALANCE_NAME
, SUBSTR(PAI1.ACTION_INFORMATION5
, 1
, 2) NI_TYPE
, TO_NUMBER(PAI2.ACTION_INFORMATION4) BALANCE_VALUE
FROM PAY_ACTION_INFORMATION PAI1
, PAY_ACTION_INFORMATION PAI2
, PAY_ASSIGNMENT_ACTIONS PAA1
WHERE PAA1.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCE DEFINITION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCES'
AND PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1
AND PAA1.ASSIGNMENT_ACTION_ID = PAI2.ACTION_CONTEXT_ID
AND PAI1.ACTION_INFORMATION1 IS NULL UNION SELECT PAI2.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI1.ACTION_INFORMATION4
, 1
, 30) BALANCE_NAME
, SUBSTR(PAI1.ACTION_INFORMATION5
, 1
, 2) NI_TYPE
, TO_NUMBER(PAI2.ACTION_INFORMATION4) BALANCE_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ACTION_INFORMATION PAI1
, PAY_ACTION_INFORMATION PAI2
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE LCK.LOCKING_ACTION_ID = PAI2.ACTION_CONTEXT_ID
AND LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAA1.PAYROLL_ACTION_ID = PAI1.ACTION_INFORMATION1
AND PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCE DEFINITION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCES'
AND PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND PAI1.ACTION_INFORMATION1 IS NOT NULL

Columns