View: PAY_EMEA_USR_ELE_ACTION_INFO_V

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

View Text

SELECT PAI2.ACTION_CONTEXT_ID
, DECODE(PAI2.ACTION_INFORMATION8
, NULL
, PAI1.ACTION_INFORMATION4
, PAI1.ACTION_INFORMATION4 || ' (' || PAI2.ACTION_INFORMATION8 || ')' ) NARRATIVE
, PAI2.ACTION_INFORMATION3 CONTEXT
, PAI2.ACTION_INFORMATION9 CONTEXT_DESCRIPTION
, DECODE(PAI1.ACTION_INFORMATION6
, 'D'
, FND_DATE.DATE_TO_DISPLAYDATE(FND_DATE.CANONICAL_TO_DATE(PAI2.ACTION_INFORMATION4))
, PAI2.ACTION_INFORMATION4) AMOUNT
, PAI2.ACTION_INFORMATION5 MAIN_SEQ
, PAI2.ACTION_INFORMATION6 MULTI_SEQ
, PAI2.ACTION_INFORMATION7 COLUMN_SEQ
FROM PAY_ACTION_INFORMATION PAI2
, PAY_ASSIGNMENT_ACTIONS APAA
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PPAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ACTION_INFORMATION PAI1
WHERE PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT INFO'
AND PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1
AND PAI1.ACTION_INFORMATION3 = PAI2.ACTION_INFORMATION2
AND PAI1.ACTION_INFORMATION5 = 'F'
AND PAI2.ACTION_CONTEXT_ID = APAA.ASSIGNMENT_ACTION_ID
AND NVL(APAA.SOURCE_ACTION_ID
, APAA.ASSIGNMENT_ACTION_ID) = LCK.LOCKING_ACTION_ID
AND LCK.LOCKED_ACTION_ID = PPAA.ASSIGNMENT_ACTION_ID
AND PPAA.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 APAA.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND ( (NVL(PAI1.ACTION_INFORMATION7
, PAI2.ACTION_INFORMATION3)=PAI2.ACTION_INFORMATION3) OR (PAI1.ACTION_INFORMATION7 IS NULL
AND PAI2.ACTION_INFORMATION3 IS NULL)) ORDER BY NVL(TO_NUMBER(PAI2.ACTION_INFORMATION8)
, 1) DESC
, TO_NUMBER(PAI2.ACTION_INFORMATION5)
, NVL(TO_NUMBER(PAI2.ACTION_INFORMATION6)
, 0)
, TO_NUMBER(PAI2.ACTION_INFORMATION7)

Columns