APPS.POS_MERGE_SUPPLIER_PKG dependencies on IBY_PMT_INSTR_USES_ALL

Line 5: instrument_type iby_pmt_instr_uses_all.instrument_type%TYPE,

1: PACKAGE BODY POS_MERGE_SUPPLIER_PKG AS
2: /* $Header: POSMRGSUPB.pls 120.1.12020000.3 2012/07/23 20:30:32 yaoli ship $ */
3:
4: TYPE bank_dtls_rec_type IS RECORD(
5: instrument_type iby_pmt_instr_uses_all.instrument_type%TYPE,
6: instrument_id iby_pmt_instr_uses_all.instrument_id%TYPE,
7: payment_function iby_pmt_instr_uses_all.payment_function%TYPE);
8:
9: TYPE bank_dtls_tab_type IS TABLE OF bank_dtls_rec_type INDEX BY BINARY_INTEGER;

Line 6: instrument_id iby_pmt_instr_uses_all.instrument_id%TYPE,

2: /* $Header: POSMRGSUPB.pls 120.1.12020000.3 2012/07/23 20:30:32 yaoli ship $ */
3:
4: TYPE bank_dtls_rec_type IS RECORD(
5: instrument_type iby_pmt_instr_uses_all.instrument_type%TYPE,
6: instrument_id iby_pmt_instr_uses_all.instrument_id%TYPE,
7: payment_function iby_pmt_instr_uses_all.payment_function%TYPE);
8:
9: TYPE bank_dtls_tab_type IS TABLE OF bank_dtls_rec_type INDEX BY BINARY_INTEGER;
10:

Line 7: payment_function iby_pmt_instr_uses_all.payment_function%TYPE);

3:
4: TYPE bank_dtls_rec_type IS RECORD(
5: instrument_type iby_pmt_instr_uses_all.instrument_type%TYPE,
6: instrument_id iby_pmt_instr_uses_all.instrument_id%TYPE,
7: payment_function iby_pmt_instr_uses_all.payment_function%TYPE);
8:
9: TYPE bank_dtls_tab_type IS TABLE OF bank_dtls_rec_type INDEX BY BINARY_INTEGER;
10:
11: TYPE uda_rec_tbl_type IS TABLE OF pos_supp_prof_ext_b%ROWTYPE INDEX BY BINARY_INTEGER;

Line 760: -- Bug 14261475 - merge performance: full table scan on iby_pmt_instr_uses_all

756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2
759: ) IS
760: -- Bug 14261475 - merge performance: full table scan on iby_pmt_instr_uses_all
761: CURSOR bank_cur IS
762: SELECT paymentinstrumentuseseo.instrument_type,
763: paymentinstrumentuseseo.instrument_id,
764: paymentinstrumentuseseo.payment_function

Line 765: FROM iby_pmt_instr_uses_all paymentinstrumentuseseo

761: CURSOR bank_cur IS
762: SELECT paymentinstrumentuseseo.instrument_type,
763: paymentinstrumentuseseo.instrument_id,
764: paymentinstrumentuseseo.payment_function
765: FROM iby_pmt_instr_uses_all paymentinstrumentuseseo
766: --iby_ext_bank_accounts_v ibyextbankaccts
767: WHERE --paymentinstrumentuseseo.instrument_id = ibyextbankaccts.bank_account_id AND
768: paymentinstrumentuseseo.instrument_type = 'BANKACCOUNT'
769: --Enforce the IBY_PMT_INSTR_USES_ALL_N1 index PAYMENT_FLOW,EXT_PMT_PARTY_ID

Line 769: --Enforce the IBY_PMT_INSTR_USES_ALL_N1 index PAYMENT_FLOW,EXT_PMT_PARTY_ID

765: FROM iby_pmt_instr_uses_all paymentinstrumentuseseo
766: --iby_ext_bank_accounts_v ibyextbankaccts
767: WHERE --paymentinstrumentuseseo.instrument_id = ibyextbankaccts.bank_account_id AND
768: paymentinstrumentuseseo.instrument_type = 'BANKACCOUNT'
769: --Enforce the IBY_PMT_INSTR_USES_ALL_N1 index PAYMENT_FLOW,EXT_PMT_PARTY_ID
770: AND paymentinstrumentuseseo.payment_flow IN
771: (SELECT lookup_code FROM fnd_lookup_values
772: WHERE lookup_type = 'IBY_PAYMENT_FLOW'
773: AND language = userenv('LANG'))

Line 785: iby_pmt_instr_uses_all instr

781: AND /* Excluding the accounts that are already associated*/
782: paymentinstrumentuseseo.instrument_id NOT IN
783: (SELECT instrument_id
784: FROM iby_external_payees_all extpayee,
785: iby_pmt_instr_uses_all instr
786: WHERE extpayee.payee_party_id = p_to_party
787: AND extpayee.org_id IS NULL
788: AND extpayee.party_site_id IS NULL
789: AND extpayee.supplier_site_id IS NULL