APPS.OKL_ARINTF_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 790: FROM OKL_K_HEADERS_FULL_V khr

786: , khr.contract_number
787: , khr.application_id app_id
788: , khr.BILL_TO_SITE_USE_ID
789: , khr.CURRENCY_CODE
790: FROM OKL_K_HEADERS_FULL_V khr
791: , OKC_K_PARTY_ROLES_B CPR
792: WHERE khr.ID = cpr.chr_id
793: AND cpr.rle_code = 'LESSEE'
794: AND khr.ID = cp_khr_id;

Line 826: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

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,
829: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
830: SELECT instrument_payment_use_id

Line 828: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,

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,
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

Line 844: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

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,
846: p_currency_code okl_k_headers_full_v.currency_code%type
847: ) IS
848: Select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(instr_assignment_id),

Line 846: p_currency_code okl_k_headers_full_v.currency_code%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,
846: p_currency_code okl_k_headers_full_v.currency_code%type
847: ) IS
848: Select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(instr_assignment_id),
849: '1' || to_char(instr_assignment_id))), 2)
850: from IBY_FNDCPT_payer_assgn_instr_v