APPS.IBE_PAYMENT_INT_PVT dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 274: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

270: l_assignment_attr.Start_Date := sysdate;
271:
272:
273: select count(*) into l_primary_card_present
274: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V
275: where party_id = p_party_id
276: and order_of_preference = 1
277: and cust_account_id is null
278: and org_id is null

Line 287: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

283:
284: IF (l_primary_card_present >= 1) THEN
285:
286: select nvl(max(order_of_preference),0)+1 into l_order_of_preference
287: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V
288: where party_id = p_party_id
289: and cust_account_id is null
290: and org_id is null
291: and acct_site_use_id is null

Line 304: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

300: END IF;
301:
302:
303: /* select nvl(max(order_of_preference),0)+1 into l_order_of_preference
304: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V
305: where party_id = p_party_id;
306:
307: l_assignment_attr.Priority := l_order_of_preference;*/
308:

Line 703: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

699: c_org_id NUMBER,
700: c_cust_accnt_id NUMBER) is
701:
702: SELECT instr_assignment_id
703: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
704: WHERE instr_assignment_id = c_pmt_id
705: AND party_id = c_party_id
706: AND org_id = c_org_id
707: AND cust_account_id = c_cust_accnt_id

Line 720: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

716: and rownum <2 ;
717:
718: CURSOR c_assignment_for_instrument(c_instr_id NUMBER, c_party_id NUMBER, c_org_id NUMBER, c_cust_accnt_id NUMBER ) is
719: SELECT instr_assignment_id
720: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
721: WHERE instrument_id = c_instr_id
722: AND party_id = c_party_id
723: AND cust_account_id = c_cust_accnt_id
724: AND org_id = c_org_id

Line 796: --c) Next, we look at IBY_FNDCPT_PAYER_ASSGN_INSTR_V to get the corresponding assignment_id.

792: EXIT when c_instrument_data%NOTFOUND;
793: END LOOP;
794:
795:
796: --c) Next, we look at IBY_FNDCPT_PAYER_ASSGN_INSTR_V to get the corresponding assignment_id.
797: FOR rec_assignment_for_instrument in c_assignment_for_instrument(l_instrument_id,
798: rec_oneclick_data.party_id,
799: rec_oneclick_data.cust_account_id,
800: rec_oneclick_data.org_id) LOOP

Line 870: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

866: AND preference_name = 'PRIMARY_CARD';
867:
868: cursor c_check_assignment_id (c_instrument_id NUMBER, c_party_id NUMBER) is
869: SELECT INSTR_ASSIGNMENT_ID, order_of_preference
870: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
871: WHERE instrument_id = c_instrument_id
872: AND party_id = c_party_id
873: AND org_id IS NULL
874: AND cust_account_id IS NULL