DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PAY_EXTERNAL_ACCOUNTS

Line 652: , pay_external_accounts pea

648: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
649: pea.segment4,
650: pea.segment2
651: FROM pay_org_payment_methods_f popm
652: , pay_external_accounts pea
653: WHERE org_payment_method_id = p_org_payment_method_id
654: AND popm.external_account_id = pea.external_account_id
655: AND p_effective_date between popm.EFFECTIVE_START_DATE
656: and popm.EFFECTIVE_END_DATE;

Line 668: , pay_external_accounts pea

664: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
665: pea.segment4,
666: pea.segment2
667: FROM pay_personal_payment_methods_f pppm
668: , pay_external_accounts pea
669: WHERE pppm.personal_payment_method_id = p_per_pay_method
670: AND pppm.external_account_id = pea.external_account_id
671: AND p_effective_date between pppm.EFFECTIVE_START_DATE
672: and pppm.EFFECTIVE_END_DATE;