View: PAY_US_PRE_PAYMENTS_V

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

View Text

SELECT PPP.PRE_PAYMENT_ID
, PPP.PERSONAL_PAYMENT_METHOD_ID
, PPP.ASSIGNMENT_ACTION_ID
, PPP.ORG_PAYMENT_METHOD_ID
, PPP.VALUE
, PPP.BASE_CURRENCY_VALUE
, PPP.SOURCE_ACTION_ID
, PPP.PREPAYMENT_ACTION_ID
, PAA_CHECK.SERIAL_NUMBER SERIAL_NUMBER
, PPA_CHECK.ACTION_TYPE ACTION_TYPE
, PAA_CHECK.ASSIGNMENT_ACTION_ID CHECK_ASSIGNMENT_ACTION_ID
, PAA_PRE.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
FROM PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAA_PRE
, PAY_ASSIGNMENT_ACTIONS PAA_CHECK
, PAY_PAYROLL_ACTIONS PPA_CHECK
, PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKED_ACTION_ID = PAA_PRE.ASSIGNMENT_ACTION_ID
AND PAA_CHECK.ASSIGNMENT_ACTION_ID = PAI.LOCKING_ACTION_ID
AND PPA_CHECK.PAYROLL_ACTION_ID = PAA_CHECK.PAYROLL_ACTION_ID
AND PPA_CHECK.ACTION_TYPE IN ('H'
, 'E'
, 'M')
AND PAA_CHECK.ACTION_STATUS = 'C'
AND PAA_CHECK.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID
AND POPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PPA_CHECK.EFFECTIVE_DATE BETWEEN POPM.EFFECTIVE_START_DATE
AND POPM.EFFECTIVE_END_DATE UNION SELECT PPP.PRE_PAYMENT_ID
, PPP.PERSONAL_PAYMENT_METHOD_ID
, PPP.ASSIGNMENT_ACTION_ID
, PPP.ORG_PAYMENT_METHOD_ID
, PPP.VALUE
, PPP.BASE_CURRENCY_VALUE
, PPP.SOURCE_ACTION_ID
, PPP.PREPAYMENT_ACTION_ID
, NULL SERIAL_NUMBER
, NULL ACTION_TYPE
, 0 CHECK_ASSIGNMENT_ACTION_ID
, 0 PAYROLL_ACTION_ID
FROM PAY_PRE_PAYMENTS PPP
WHERE NOT EXISTS (SELECT 1
FROM PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAA.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID)

Columns