eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 302: FROM pay_external_accounts pea

298: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
299: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
300: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
301: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
302: FROM pay_external_accounts pea
303: WHERE p_ext_act_id = pea.external_account_id;
304:
305: l_proc_name varchar2(50) := 'pay_payment_xml_pkg.gen_bank_header_xml';
306: l_bank_name varchar2(2000);

Line 393: , pay_external_accounts pea

389: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
390: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
391: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
392: FROM pay_org_payment_methods_f popm
393: , pay_external_accounts pea
394: WHERE org_payment_method_id = p_org_payment_method_id
395: AND popm.external_account_id = pea.external_account_id
396: AND p_effective_date between popm.EFFECTIVE_START_DATE
397: and popm.EFFECTIVE_END_DATE;

Line 419: , pay_external_accounts pea

415: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
416: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code),
417: pppm.payee_id,pppm.payee_type
418: FROM pay_personal_payment_methods_f pppm
419: , pay_external_accounts pea
420: WHERE pppm.personal_payment_method_id = p_per_pay_method
421: AND pppm.external_account_id = pea.external_account_id
422: AND p_effective_date between pppm.EFFECTIVE_START_DATE
423: and pppm.EFFECTIVE_END_DATE;

Line 444: , pay_external_accounts pea

440: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
441: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
442: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
443: FROM pay_org_payment_methods_f popm
444: , pay_external_accounts pea
445: WHERE org_payment_method_id = p_org_pay_method
446: AND popm.external_account_id = pea.external_account_id
447: AND p_effective_date between popm.EFFECTIVE_START_DATE
448: and popm.EFFECTIVE_END_DATE;