APPS.HZ_CUSTOMER_INT dependencies on IBY_PMT_INSTR_USES_ALL

Line 4081: iby_pmt_instr_uses_all ipi,

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
4085: WHERE

Line 4104: FROM iby_pmt_instr_uses_all ipi

4100:
4101:
4102: cursor get_modifying_priorities(l_ext_pmt_party_id in number) is
4103: select ipi.instrument_payment_use_id
4104: FROM iby_pmt_instr_uses_all ipi
4105: WHERE ipi.ext_pmt_party_id = l_ext_pmt_party_id
4106: AND ipi.order_of_preference = -1
4107: order by instrument_payment_use_id;
4108:

Line 4132: update iby_pmt_instr_uses_all

4128:
4129: for j in 1..i_instrument_payment_use_id.count loop
4130:
4131: IF i_max_order_of_preference(i) = -1 THEN
4132: update iby_pmt_instr_uses_all
4133: set order_of_preference = j
4134: where instrument_payment_use_id = i_instrument_payment_use_id(j);
4135:
4136: ELSE

Line 4137: update iby_pmt_instr_uses_all

4133: set order_of_preference = j
4134: where instrument_payment_use_id = i_instrument_payment_use_id(j);
4135:
4136: ELSE
4137: update iby_pmt_instr_uses_all
4138: set order_of_preference = i_max_order_of_preference(i) +j
4139: where instrument_payment_use_id = i_instrument_payment_use_id(j);
4140:
4141:

Line 4154: iby_pmt_instr_uses_all ipi,

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
4158: WHERE cbi.orig_system_address_ref is null

Line 4177: iby_pmt_instr_uses_all ipi,

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

Line 4220: update iby_pmt_instr_uses_all

4216: i_instrument_payment_use_id,i_order_of_preference;
4217: close get_cust_bank_acct_priority;
4218:
4219: forall i in 1..i_instrument_payment_use_id.count
4220: update iby_pmt_instr_uses_all
4221: set order_of_preference = i_order_of_preference(i) +1
4222: where instrument_payment_use_id = i_instrument_payment_use_id(i);
4223:
4224: open get_site_bank_acct_priority;

Line 4230: update iby_pmt_instr_uses_all

4226: s_instrument_payment_use_id,s_order_of_preference;
4227: close get_site_bank_acct_priority;
4228:
4229: forall i in 1..s_instrument_payment_use_id.count
4230: update iby_pmt_instr_uses_all
4231: set order_of_preference = s_order_of_preference(i) +1
4232: where instrument_payment_use_id = s_instrument_payment_use_id(i);
4233:
4234: END update_bank_priority;