APPS.IBE_PAYMENT_INT_PVT dependencies on IBY_UPG_INSTRUMENTS

Line 714: FROM IBY_UPG_INSTRUMENTS

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

Line 935: -- (IBY_UPG_INSTRUMENTS)

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

Line 937: FROM IBY_UPG_INSTRUMENTS

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