eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_IE_ELEMENT_F_INFO_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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