663: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NAME', pea.territory_code),
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