APPS.IBE_PAYMENT_INT_PVT dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 272: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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

Line 285: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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

Line 302: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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

Line 701: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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

Line 718: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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

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

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

Line 868: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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