View: PAY_EMP_PAYMENT_ACTION_INFO_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_EMP_PAYMENT_ACTION_INFO_V

View Text

SELECT PAI.ACTION_INFORMATION1
, PAI.ACTION_INFORMATION2
, PAI.ACTION_INFORMATION3
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PAI.ACTION_CONTEXT_ID
, PAF.PERSON_ID
, PAI.EFFECTIVE_DATE
FROM PAY_ACTION_INFORMATION PAI
, PAY_ACTION_INFORMATION PAI2
, PER_ALL_ASSIGNMENTS_F PAF
, PER_ALL_ASSIGNMENTS_F PAF2
WHERE PAI.ACTION_CONTEXT_ID >= PAI2.ACTION_CONTEXT_ID
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE PAYMENT INFORMATION'
AND PAF2.ASSIGNMENT_ID = PAI2.ASSIGNMENT_ID
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE PAYMENT INFORMATION'
AND PAI.EFFECTIVE_DATE = PAI2.EFFECTIVE_DATE
AND PAF.PERSON_ID = PAF2.PERSON_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PAI.EFFECTIVE_DATE BETWEEN PAF2.EFFECTIVE_START_DATE
AND PAF2.EFFECTIVE_END_DATE
AND EXISTS (SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS PAA
WHERE NVL(PAA.TAX_UNIT_ID
, -9999) = NVL(PAI.TAX_UNIT_ID
, -9999)
AND PAA.ASSIGNMENT_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAA.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID)
AND EXISTS (SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS PAA2
WHERE NVL(PAA2.TAX_UNIT_ID
, -9999) = NVL(PAI2.TAX_UNIT_ID
, -9999)
AND PAA2.ASSIGNMENT_ACTION_ID = PAI2.ACTION_CONTEXT_ID
AND PAA2.ASSIGNMENT_ID = PAI2.ASSIGNMENT_ID)
AND EXISTS (SELECT 'X'
FROM PAY_ACTION_INTERLOCKS PACI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PACI.LOCKING_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAA.ASSIGNMENT_ACTION_ID = PACI.LOCKED_ACTION_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PAY_US_EMPLOYEE_PAYSLIP_WEB.CHECK_EMP_PERSONAL_PAYMENT ( PAF.ASSIGNMENT_ID
, PAF.PAYROLL_ID
, PACI.LOCKED_ACTION_ID
, PAI.EFFECTIVE_DATE) = 'Y') GROUP BY PAI.EFFECTIVE_DATE
, PAI.ACTION_CONTEXT_ID
, PAI.ACTION_INFORMATION1
, PAI.ACTION_INFORMATION2
, PAI.ACTION_INFORMATION3
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PAF.PERSON_ID

Columns