DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 805: ,pay_external_accounts pea

801: /*Per'l Payment Method Bank_number for CA, Bank Name for US */
802: ,pea.segment4 /* Per'l Payment Method Transit_code */
803: ,pea.segment3 /* Per'l Payment Method Account_Number */
804: from pay_personal_payment_methods_f pppm /*added newly to fix bug#2133040 */
805: ,pay_external_accounts pea
806: where pppm.personal_payment_method_id = cp_personal_paymeth_id
807: and cp_effective_date between pppm.effective_start_date and
808: pppm.effective_end_date /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
809: and pppm.external_account_id = pea.external_account_id(+);