APPS.IBE_PAYMENT_INT_PVT dependencies on IBY_UPG_INSTRUMENTS

Line 712: FROM IBY_UPG_INSTRUMENTS

708: AND payment_function = 'CUSTOMER_PAYMENT';
709:
710: CURSOR c_instrument_data(c_pmt_id NUMBER ) is
711: SELECT instrument_id
712: FROM IBY_UPG_INSTRUMENTS
713: WHERE bank_account_id = c_pmt_id
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

Line 933: -- (IBY_UPG_INSTRUMENTS)

929: --2. Loop: on the users
930: FOR rec_get_users_w_primary_cc_set in c_get_users_w_primary_cc_set LOOP
931:
932: --a) Get the equivalent identifier for the credit card from the IBY mapping table
933: -- (IBY_UPG_INSTRUMENTS)
934: SELECT instrument_id into l_instrument_id
935: FROM IBY_UPG_INSTRUMENTS
936: WHERE bank_account_id = rec_get_users_w_primary_cc_set.preference_value
937: and rownum < 2;

Line 935: FROM IBY_UPG_INSTRUMENTS

931:
932: --a) Get the equivalent identifier for the credit card from the IBY mapping table
933: -- (IBY_UPG_INSTRUMENTS)
934: SELECT instrument_id into l_instrument_id
935: FROM IBY_UPG_INSTRUMENTS
936: WHERE bank_account_id = rec_get_users_w_primary_cc_set.preference_value
937: and rownum < 2;
938:
939: IF p_debug_flag = 'T' THEN