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.HZ_CUSTOMER_INT dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 4080: FROM iby_external_payers_all iep,

4076: PROCEDURE upd_non_primary_bank_priority(p_request_id IN NUMBER) IS
4077:
4078: cursor get_cust_bank_acct_priority is
4079: select distinct ipi.ext_pmt_party_id, max(ipi.order_of_preference), count(ipi.instrument_payment_use_id)
4080: FROM iby_external_payers_all iep,
4081: iby_pmt_instr_uses_all ipi,
4082: iby_ext_bank_accounts eba,
4083: hz_cust_accounts hca,
4084: ra_customer_banks_int_all cbi

Line 4153: FROM iby_external_payers_all iep,

4149: PROCEDURE update_bank_priority (p_request_id IN NUMBER) IS
4150:
4151: cursor get_cust_bank_acct_priority is
4152: select ipi.instrument_payment_use_id, ipi.order_of_preference
4153: FROM iby_external_payers_all iep,
4154: iby_pmt_instr_uses_all ipi,
4155: iby_ext_bank_accounts eba,
4156: hz_cust_accounts hca,
4157: ra_customer_banks_int_all cbi

Line 4176: FROM iby_external_payers_all iep,

4172: order by ipi.order_of_preference desc;
4173:
4174: cursor get_site_bank_acct_priority is
4175: select ipi.instrument_payment_use_id, ipi.order_of_preference
4176: FROM iby_external_payers_all iep,
4177: iby_pmt_instr_uses_all ipi,
4178: iby_ext_bank_accounts eba,
4179: hz_cust_acct_sites_all hca,
4180: hz_cust_site_uses_all hcs,