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 723: from okc_k_headers_b b

719: END IF;
720: FORALL indx in l_contract_tbl.first..l_contract_tbl.last
721: update okl_ext_billing_interface a
722: set contract_id = (select id
723: from okc_k_headers_b b
724: where b.contract_number = a.contract_number)
725: where rowid = l_rowid_tbl(indx);
726: COMMIT;
727: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 801: okc_k_headers_b chr

797: OKL_AE_TMPT_SETS AES,
798: OKL_PRODUCTS PDT,
799: OKL_STRM_TYPE_V STY,
800: okl_k_headers khr,
801: okc_k_headers_b chr
802: WHERE
803: GTLV.GTT_ID = GTTV.ID AND
804: GTTV.GTS_ID = GTSV.ID AND
805: GTTV.TMPT_STATUS = 'ACTIVE' AND

Line 831: okc_k_headers_b chr

827: OKL_AE_TMPT_SETS AES,
828: OKL_PRODUCTS PDT,
829: OKL_STRM_TYPE_V STY,
830: okl_k_headers khr,
831: okc_k_headers_b chr
832: WHERE
833: GTLV.GTT_ID = GTTV.ID AND
834: GTTV.GTS_ID = GTSV.ID AND
835: GTTV.TMPT_STATUS = 'ACTIVE' AND