View: PAY_PRE_PAYMENTS_V2

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PRE_PAYMENTS_V2

View Text

SELECT AAC.ASSIGNMENT_ACTION_ID
, PPM.PRE_PAYMENT_ID
, OPM.CURRENCY_CODE
, AAC.SERIAL_NUMBER
, PPM.VALUE
, OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, OPM.EFFECTIVE_START_DATE OPM_EFFECTIVE_START_DATE
, OPM.EFFECTIVE_END_DATE OPM_EFFECTIVE_END_DATE
FROM PAY_PRE_PAYMENTS PPM
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ASSIGNMENT_ACTIONS AAC
WHERE OPM.ORG_PAYMENT_METHOD_ID = PPM.ORG_PAYMENT_METHOD_ID

Columns