View: CE_CP_PAY_V

Product:	CE - Cash Management
Description:	Cash Positioning source for Discoverer - Payroll
Implementation/DBA Data:	APPS.CE_CP_PAY_V

View Text

SELECT PREPAY.PRE_PAYMENT_ID
, CBA.BANK_ACCOUNT_ID
, ACTION.EFFECTIVE_DATE
, TO_CHAR(PREPAY.PRE_PAYMENT_ID)
, -PREPAY.BASE_CURRENCY_VALUE
, ACTION.PAYROLL_ID
, METHOD.ORG_PAYMENT_METHOD_ID FROM PAY_PRE_PAYMENTS PREPAY
, PAY_ORG_PAYMENT_METHODS_F METHOD
, PAY_PAYROLL_ACTIONS ACTION
, PAY_ASSIGNMENT_ACTIONS ASGN
, CE_BANK_ACCOUNTS CBA
WHERE PREPAY.ORG_PAYMENT_METHOD_ID = METHOD.ORG_PAYMENT_METHOD_ID AND METHOD.EXTERNAL_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID AND CBA.PAY_USE_ALLOWED_FLAG='Y' AND ACTION.ACTION_TYPE IN ('P'
, 'U'
, 'E') AND ACTION.EFFECTIVE_DATE BETWEEN METHOD.EFFECTIVE_START_DATE AND METHOD.EFFECTIVE_END_DATE AND PREPAY.ASSIGNMENT_ACTION_ID = ASGN.ASSIGNMENT_ACTION_ID AND ASGN.PAYROLL_ACTION_ID = ACTION.PAYROLL_ACTION_ID

Columns