View: PAY_EMEA_PAYMENT_VALUES_V

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

View Text

SELECT PET.ROWID ROW_ID
, PET.ELEMENT_TYPE_ID
, PIV.INPUT_VALUE_ID
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PRV.RESULT_VALUE)) RESULT_VALUE
, PET.PROCESSING_PRIORITY
, PAC.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID
FROM PAY_ACTION_INTERLOCKS PAC
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULTS PRR
, PAY_RUN_RESULT_VALUES PRV
WHERE PRR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.STATUS IN ('P'
, 'PA')
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND PIV.NAME = 'PAY VALUE'
AND PIV.UOM = 'M'
AND PAC.LOCKED_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAC.LOCKED_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE GROUP BY PAC.LOCKING_ACTION_ID
, PET.PROCESSING_PRIORITY
, PET.ELEMENT_TYPE_ID
, PIV.INPUT_VALUE_ID
, PET.ROWID

Columns