APPS.IBY_SUPP_BANK_MERGE_PUB dependencies on IBY_PMT_INSTR_USES_ALL

Line 27: FROM iby_pmt_instr_uses_all

23: ) IS
24:
25: CURSOR get_from_instr_use_dtls (cp_instrument_payment_use_id IN NUMBER) IS
26: SELECT *
27: FROM iby_pmt_instr_uses_all
28: WHERE instrument_payment_use_id = cp_instrument_payment_use_id;
29:
30: CURSOR max_order_of_pref (cp_ext_payee_id IN NUMBER) IS
31: SELECT MAX(order_of_preference)

Line 32: FROM iby_pmt_instr_uses_all

28: WHERE instrument_payment_use_id = cp_instrument_payment_use_id;
29:
30: CURSOR max_order_of_pref (cp_ext_payee_id IN NUMBER) IS
31: SELECT MAX(order_of_preference)
32: FROM iby_pmt_instr_uses_all
33: WHERE ext_pmt_party_id = cp_ext_payee_id;
34:
35: CURSOR cur_is_ownership_exists(cp_to_party_id IN NUMBER, cp_bank_act_id IN NUMBER) IS
36: SELECT 'Y'

Line 49: rec_get_from_instr_use_dtls iby_pmt_instr_uses_all%ROWTYPE;

45: WHERE ext_bank_account_id = cp_bank_act_id
46: AND account_owner_party_id = cp_from_party_id
47: AND NVL (end_date, Sysdate) >= Sysdate;
48:
49: rec_get_from_instr_use_dtls iby_pmt_instr_uses_all%ROWTYPE;
50:
51: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.BANK_ACCOUNTS_MERGE(MERGE_BANKS)';
52: g_mesg VARCHAR2(1000) := '';
53: L_BANK_ACCOUNT_EXITS BOOLEAN;

Line 116: INSERT INTO iby_pmt_instr_uses_all(

112: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
113: g_mesg := ' Inserting record into Instruments l_max_order_of_pref => '|| l_max_order_of_pref ;
114: fnd_file.put_line(fnd_file.log, g_mesg);
115: END IF;
116: INSERT INTO iby_pmt_instr_uses_all(
117: INSTRUMENT_PAYMENT_USE_ID,
118: PAYMENT_FLOW ,
119: EXT_PMT_PARTY_ID ,
120: INSTRUMENT_TYPE ,

Line 155: IBY_PMT_INSTR_USES_ALL_S.NEXTVAL ,

151: ATTRIBUTE14 ,
152: ATTRIBUTE15
153: )
154: VALUES(
155: IBY_PMT_INSTR_USES_ALL_S.NEXTVAL ,
156: rec_get_from_instr_use_dtls.PAYMENT_FLOW ,
157: p_to_ext_payee_id ,
158: rec_get_from_instr_use_dtls.INSTRUMENT_TYPE ,
159: rec_get_from_instr_use_dtls.INSTRUMENT_ID ,

Line 344: UPDATE iby_pmt_instr_uses_all

340: g_mesg := ' Inactivating instruments at site level';
341: fnd_file.put_line(fnd_file.log, g_mesg);
342: END IF;
343:
344: UPDATE iby_pmt_instr_uses_all
345: SET end_date = SYSDATE
346: WHERE instrument_payment_use_id = from_instr_pmt_use_list(I)
347: AND NVL(end_date,SYSDATE) >= SYSDATE/*Bug 14587066 */;
348:

Line 553: Iby_pmt_instr_uses_all uses,

549: Uses.instrument_payment_use_id ,
550: Payee.ext_payee_id,
551: Uses.instrument_id bank_account_id
552: FROM
553: Iby_pmt_instr_uses_all uses,
554: Iby_external_payees_all payee
555: WHERE
556: Payee.ext_payee_id = uses.ext_pmt_party_id
557: AND uses.payment_function = 'PAYABLES_DISB'

Line 588: rec_get_from_instr_use_dtls iby_pmt_instr_uses_all%ROWTYPE;

584: to_instr_pmt_use_list Id_Tab_Type;
585: to_bank_account_id_list Id_Tab_Type;
586: to_ext_payee_id_list Id_Tab_Type;
587:
588: rec_get_from_instr_use_dtls iby_pmt_instr_uses_all%ROWTYPE;
589:
590: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.BANK_ACCOUNTS_MERGE';
591: g_mesg VARCHAR2(1000) := '';
592: L_BANK_ACCOUNT_EXITS BOOLEAN;

Line 823: UPDATE iby_pmt_instr_uses_all

819:
820: -- Added the filter condition in inner query for Bug 12910775, do not inactivate the sites of the same supplier
821:
822:
823: UPDATE iby_pmt_instr_uses_all
824: SET end_date = SYSDATE
825: WHERE ext_pmt_party_id IN
826: (SELECT ext_payee_id
827: FROM Iby_external_payees_all