DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on IBY_EXTERNAL_PAYERS_ALL

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