DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on IBY_EXT_BANK_ACCOUNTS

Line 4082: iby_ext_bank_accounts eba,

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
4085: WHERE
4086: cbi.request_id = p_request_id

Line 4155: iby_ext_bank_accounts eba,

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
4158: WHERE cbi.orig_system_address_ref is null
4159: AND cbi.request_id = p_request_id

Line 4178: iby_ext_bank_accounts eba,

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,
4181: hz_cust_accounts hcu,
4182: ra_customer_banks_int_all cbi