View: PAY_APAC_BALS_ACTION_INFO_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_APAC_BALS_ACTION_INFO_V

View Text

SELECT PAI2.ACTION_CONTEXT_ID
, DECODE(PAI2.ACTION_INFORMATION5
, NULL
, PAI1.ACTION_INFORMATION4
, PAI1.ACTION_INFORMATION4 || ' (' || PAI2.ACTION_INFORMATION5 || ')') NARRATIVE
, PAI2.ACTION_INFORMATION2 CONTEXT
, PAI2.ACTION_INFORMATION6 CONTEXT_DESCRIPTION
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI2.ACTION_INFORMATION4) VALUE
FROM PAY_ACTION_INFORMATION PAI2
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_ACTION_INFORMATION PAI1
WHERE 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 PAI2.ACTION_CONTEXT_ID = PAA2.ASSIGNMENT_ACTION_ID
AND NVL(PAA2.SOURCE_ACTION_ID
, PAA2.ASSIGNMENT_ACTION_ID) = LCK.LOCKING_ACTION_ID
AND LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAA1.SOURCE_ACTION_ID IS NULL
AND PAA1.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPA.PAYROLL_ACTION_ID = NVL (PAI1.ACTION_INFORMATION1
, PPA.PAYROLL_ACTION_ID)
AND PAA2.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND ((NVL(PAI1.ACTION_INFORMATION6
, PAI2.ACTION_INFORMATION2)=PAI2.ACTION_INFORMATION2) OR (PAI1.ACTION_INFORMATION6 IS NULL
AND PAI2.ACTION_INFORMATION2 IS NULL)) ORDER BY NVL(TO_NUMBER(PAI2.ACTION_INFORMATION5)
, 1) DESC
, PAI2.ACTION_INFORMATION_ID

Columns