DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 822: ,pay_external_accounts pea

818: /*Per'l Payment Method Bank_number for CA, Bank Name for US */
819: ,pea.segment4 /* Per'l Payment Method Transit_code */
820: ,pea.segment3 /* Per'l Payment Method Account_Number */
821: from pay_personal_payment_methods_f pppm /*added newly to fix bug#2133040 */
822: ,pay_external_accounts pea
823: where pppm.personal_payment_method_id = cp_personal_paymeth_id
824: and cp_effective_date between pppm.effective_start_date and
825: pppm.effective_end_date /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
826: and pppm.external_account_id = pea.external_account_id(+);