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 277: FROM iby_fndcpt_payer_assgn_instr_v assign

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

Line 499: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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