DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PAY_EXTERNAL_ACCOUNTS

Line 464: , pay_external_accounts pea

460: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
461: pea.segment4,
462: pea.segment2
463: FROM pay_org_payment_methods_f popm
464: , pay_external_accounts pea
465: WHERE org_payment_method_id = p_org_payment_method_id
466: AND popm.external_account_id = pea.external_account_id
467: AND p_effective_date between popm.EFFECTIVE_START_DATE
468: and popm.EFFECTIVE_END_DATE;

Line 480: , pay_external_accounts pea

476: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
477: pea.segment4,
478: pea.segment2
479: FROM pay_personal_payment_methods_f pppm
480: , pay_external_accounts pea
481: WHERE pppm.personal_payment_method_id = p_per_pay_method
482: AND pppm.external_account_id = pea.external_account_id
483: AND p_effective_date between pppm.EFFECTIVE_START_DATE
484: and pppm.EFFECTIVE_END_DATE;