APPS.IBE_CUSTOMER_PVT dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 251: FROM iby_fndcpt_payer_assgn_instr_v assign

247:
248:
249: CURSOR c_getPrimaryCCInfo(l_cust_acct_id NUMBER,l_party_id NUMBER,l_msite_id NUMBER) IS
250: SELECT assign.instr_assignment_id
251: FROM iby_fndcpt_payer_assgn_instr_v assign
252: WHERE assign.party_id = l_party_id
253: AND assign.order_of_preference = 1
254: AND assign.org_id is null
255: AND assign.cust_account_id is null

Line 276: FROM iby_fndcpt_payer_assgn_instr_v assign

272: and msite_information1 = assign.card_issuer_code);
273:
274: CURSOR c_getFirstCCInfo(l_cust_acct_id NUMBER,l_party_id NUMBER,l_msite_id NUMBER) IS
275: SELECT assign.instr_assignment_id
276: FROM iby_fndcpt_payer_assgn_instr_v assign
277: WHERE assign.party_id = l_party_id
278: AND assign.org_id is null
279: AND assign.cust_account_id is null
280: AND assign.instrument_type = 'CREDITCARD'

Line 497: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

493: IS
494:
495: cursor C_get_primary_credit_card(c_party_id NUMBER) is
496: SELECT instr_assignment_id
497: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
498: WHERE party_id = c_party_id
499: AND org_id is null
500: AND cust_account_id is null
501: AND acct_site_use_id IS NULL