View: PAY_PRE_PAYMENTS_V3

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

View Text

SELECT PPP.PRE_PAYMENT_ID
, PPP.VALUE
, OPM.CURRENCY_CODE
, PPM.EXTERNAL_ACCOUNT_ID
, FLX.ID_FLEX_NUM
, OPM.EFFECTIVE_START_DATE OPM_EFFECTIVE_START_DATE
, OPM.EFFECTIVE_END_DATE OPM_EFFECTIVE_END_DATE
, PPM.EFFECTIVE_START_DATE PPM_EFFECTIVE_START_DATE
, PPM.EFFECTIVE_END_DATE PPM_EFFECTIVE_END_DATE
, OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
FROM FND_ID_FLEX_STRUCTURES_VL FLX
, PAY_PAYMENT_TYPES PTY
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PRE_PAYMENTS PPP
WHERE OPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PPM.PERSONAL_PAYMENT_METHOD_ID = PPP.PERSONAL_PAYMENT_METHOD_ID
AND OPM.PAYMENT_TYPE_ID = PTY.PAYMENT_TYPE_ID
AND FLX.ID_FLEX_STRUCTURE_NAME (+) = PTY.TERRITORY_CODE||' BANK DETAILS'

Columns