View: PAY_IE_EAR_DED_V

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

View Text

SELECT LCK.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI.ACTION_INFORMATION4
, 1
, 30) ELEMENT_NAME
, SUBSTR(PAI.ACTION_INFORMATION5
, 1
, 2) E_OR_D
, PET.RESULT_VALUE ELEMENT_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ACTION_INFORMATION PAI
, PAY_IE_PAYMENT_VALUES_V PET
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID /*AND PAI.ACTION_INFORMATION1 = PAA1.PAYROLL_ACTION_ID */
AND PAI.ACTION_CONTEXT_TYPE = 'PA'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAA1.ASSIGNMENT_ACTION_ID = PET.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PAI.ACTION_INFORMATION2
AND PET.INPUT_VALUE_ID = PAI.ACTION_INFORMATION3
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAI.ACTION_INFORMATION1 IS NULL UNION ALL SELECT LCK.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI.ACTION_INFORMATION4
, 1
, 30) ELEMENT_NAME
, SUBSTR(PAI.ACTION_INFORMATION5
, 1
, 2) E_OR_D
, PET.RESULT_VALUE ELEMENT_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ACTION_INFORMATION PAI
, PAY_IE_PAYMENT_VALUES_V PET
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAI.ACTION_INFORMATION1 = PAA1.PAYROLL_ACTION_ID
AND PAI.ACTION_CONTEXT_TYPE = 'PA'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAA1.ASSIGNMENT_ACTION_ID = PET.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PAI.ACTION_INFORMATION2
AND PET.INPUT_VALUE_ID = PAI.ACTION_INFORMATION3
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAI.ACTION_INFORMATION1 IS NOT NULL

Columns