APPS.OKL_ARINTF_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 774: FROM iby_pmt_instr_uses_all ipiu

770: IS
771: SELECT ipiu.payment_function
772: , fpc.payment_channel_code
773: , ipiu.payment_flow
774: FROM iby_pmt_instr_uses_all ipiu
775: , iby_fndcpt_pmt_chnnls_vl fpc
776: WHERE instrument_id = p_instr_use_id
777: AND fpc.instrument_type = ipiu.instrument_type;
778:

Line 824: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,

820:
821: --sosharma bug 6608452
822: --instrument_payment_use_id to be passed to IBY Bug 7162253
823: CURSOR instrument_payment_use_id_csr(
824: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
825: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
826: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
827: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
828: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,

Line 829: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS

825: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
826: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
827: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
828: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
829: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
830: SELECT instrument_payment_use_id
831: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay
832: WHERE ibyinstr.instrument_id = p_bank_id
833: AND ibyinstr.payment_flow = p_payment_flow

Line 831: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay

827: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
828: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
829: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
830: SELECT instrument_payment_use_id
831: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay
832: WHERE ibyinstr.instrument_id = p_bank_id
833: AND ibyinstr.payment_flow = p_payment_flow
834: AND pay.payment_function = p_payment_function
835: AND ibyinstr.EXT_PMT_PARTY_ID = pay.EXT_PAYER_ID

Line 841: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;

837: AND pay.org_id = p_org_id
838: AND pay.cust_account_id = p_cust_acct_id
839: AND pay.acct_site_use_id = p_site_use_id;
840:
841: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;
842:
843: CURSOR cust_instr_payment_use_id_csr (
844: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
845: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

Line 867: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)

863: )
864: and p_trx_date between NVL(assignment_start_date,p_trx_date)
865: and NVL(assignment_end_date,p_trx_date);
866:
867: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)
868: is
869: select instrument_id
870: from iby_pmt_instr_uses_all
871: where instrument_payment_use_id = p_instr_payment_use_id;

Line 870: from iby_pmt_instr_uses_all

866:
867: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)
868: is
869: select instrument_id
870: from iby_pmt_instr_uses_all
871: where instrument_payment_use_id = p_instr_payment_use_id;
872:
873: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
874:

Line 873: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;

869: select instrument_id
870: from iby_pmt_instr_uses_all
871: where instrument_payment_use_id = p_instr_payment_use_id;
872:
873: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
874:
875: BEGIN
876:
877: x_return_status := Okl_Api.G_RET_STS_SUCCESS;