VIEW: APPS.CE_CP_PAY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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