APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKC_K_HEADERS_B

Line 147: FROM okc_k_headers_b

143: WHERE name = p_stream_name;
144:
145: CURSOR get_khr_id_csr ( p_contract_number VARCHAR2 ) IS
146: SELECT id
147: FROM okc_k_headers_b
148: WHERE contract_number = p_contract_number;
149:
150: CURSOR get_currency_csr ( p_contract_number VARCHAR2 ) IS
151: SELECT currency_code

Line 152: FROM okc_k_headers_b

148: WHERE contract_number = p_contract_number;
149:
150: CURSOR get_currency_csr ( p_contract_number VARCHAR2 ) IS
151: SELECT currency_code
152: FROM okc_k_headers_b
153: WHERE contract_number = p_contract_number;
154:
155: CURSOR get_try_id_csr (cp_name VARCHAR2, cp_language VARCHAR2) IS
156: SELECT id

Line 205: l_khr_id okc_k_headers_b.id%type;

201:
202: -- ********************************
203: -- Local Variables
204: -- ********************************
205: l_khr_id okc_k_headers_b.id%type;
206: l_kle_id NUMBER;
207: l_try_id okl_trx_types_tl.id%type;
208: l_sty_id okl_strm_type_b.id%type;
209: l_currency_code fnd_currencies.currency_code%type;

Line 709: from okc_k_headers_b b

705: END IF;
706: FORALL indx in l_contract_tbl.first..l_contract_tbl.last
707: update okl_ext_billing_interface a
708: set contract_id = (select id
709: from okc_k_headers_b b
710: where b.contract_number = a.contract_number)
711: where rowid = l_rowid_tbl(indx);
712: COMMIT;
713: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 787: okc_k_headers_b chr

783: OKL_AE_TMPT_SETS AES,
784: OKL_PRODUCTS PDT,
785: OKL_STRM_TYPE_V STY,
786: okl_k_headers khr,
787: okc_k_headers_b chr
788: WHERE
789: GTLV.GTT_ID = GTTV.ID AND
790: GTTV.GTS_ID = GTSV.ID AND
791: GTTV.TMPT_STATUS = 'ACTIVE' AND

Line 817: okc_k_headers_b chr

813: OKL_AE_TMPT_SETS AES,
814: OKL_PRODUCTS PDT,
815: OKL_STRM_TYPE_V STY,
816: okl_k_headers khr,
817: okc_k_headers_b chr
818: WHERE
819: GTLV.GTT_ID = GTTV.ID AND
820: GTTV.GTS_ID = GTSV.ID AND
821: GTTV.TMPT_STATUS = 'ACTIVE' AND