View: PAY_IE_ELEMENT_F_INFO_V

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

View Text

SELECT PAI2.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI1.ACTION_INFORMATION4
, 1
, 30) ELEMENT_NAME
, TO_NUMBER(DECODE (PAI1.ACTION_INFORMATION6
, 'M'
, PAI2.ACTION_INFORMATION4
, 'D'
, FND_DATE.DATE_TO_DISPLAYDATE(FND_DATE.CANONICAL_TO_DATE(PAI2.ACTION_INFORMATION4)))) ELEMENT_VALUE
, TO_NUMBER(PAI2.ACTION_INFORMATION5) MAIN_SEQ
, TO_NUMBER(PAI2.ACTION_INFORMATION6) MULTI_SEQ
, TO_NUMBER(PAI2.ACTION_INFORMATION7) COLUMN_SEQ
FROM PAY_ACTION_INFORMATION PAI1
, PAY_ACTION_INFORMATION PAI2
, PAY_ASSIGNMENT_ACTIONS PPAA
WHERE PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAI1.ACTION_INFORMATION5 = 'F'
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 PAI2.ACTION_CONTEXT_ID = PPAA.ASSIGNMENT_ACTION_ID
AND PPAA.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND PAI1.ACTION_INFORMATION1 IS NULL UNION SELECT PAI2.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI1.ACTION_INFORMATION4
, 1
, 30) ELEMENT_NAME
, TO_NUMBER(DECODE (PAI1.ACTION_INFORMATION6
, 'M'
, PAI2.ACTION_INFORMATION4
, 'D'
, FND_DATE.DATE_TO_DISPLAYDATE(FND_DATE.CANONICAL_TO_DATE(PAI2.ACTION_INFORMATION4)))) ELEMENT_VALUE
, TO_NUMBER(PAI2.ACTION_INFORMATION5) MAIN_SEQ
, TO_NUMBER(PAI2.ACTION_INFORMATION6) MULTI_SEQ
, TO_NUMBER(PAI2.ACTION_INFORMATION7) COLUMN_SEQ
FROM PAY_ACTION_INFORMATION PAI1
, PAY_ACTION_INFORMATION PAI2
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS APAA
, PAY_ASSIGNMENT_ACTIONS PPAA
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 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 = PAI1.ACTION_INFORMATION1
AND APAA.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND PAI1.ACTION_INFORMATION5 = 'F'
AND PAI1.ACTION_INFORMATION1 IS NOT NULL

Columns