APPS.OKL_REPORT_PVT dependencies on OKL_STREAMS

Line 4489: OKL_STREAMS stm,

4485: ste.amount amount,
4486: khr.sts_code sts_code,
4487: khl.pdt_id pdt_id
4488: FROM OKL_STRM_ELEMENTS ste,
4489: OKL_STREAMS stm,
4490: okl_strm_type_v sty,
4491: okc_k_headers_b khr,
4492: OKL_K_HEADERS khl,
4493: okc_k_lines_b kle,

Line 4735: CURSOR c_ccid(cp_sty_id IN okl_streams.sty_id%TYPE,

4731: AND pym_instr.instrument_id = bnk.bank_account_id
4732: AND pym_instr.instrument_type = 'BANKACCOUNT';
4733:
4734: -- Cursor to fetch ccids for the passed product and stream type
4735: CURSOR c_ccid(cp_sty_id IN okl_streams.sty_id%TYPE,
4736: cp_pdt_id IN okl_k_headers.pdt_id%TYPE) IS
4737: SELECT aetl.code_combination_id,
4738: glv.concatenated_segments
4739: FROM okl_ae_tmpt_lnes aetl,

Line 4768: kle_id okl_streams.kle_id%TYPE,

4764: -- cursor c_streams data structure
4765: TYPE bill_rec_type IS RECORD (
4766: khr_id okc_k_headers_b.id%TYPE,
4767: bill_date okl_strm_elements.stream_element_date%TYPE,
4768: kle_id okl_streams.kle_id%TYPE,
4769: sel_id okl_strm_elements.id%TYPE,
4770: sty_id okl_streams.sty_id%TYPE,
4771: contract_number okc_k_headers_b.contract_number%TYPE,
4772: currency_code okc_k_headers_b.currency_code%TYPE,

Line 4770: sty_id okl_streams.sty_id%TYPE,

4766: khr_id okc_k_headers_b.id%TYPE,
4767: bill_date okl_strm_elements.stream_element_date%TYPE,
4768: kle_id okl_streams.kle_id%TYPE,
4769: sel_id okl_strm_elements.id%TYPE,
4770: sty_id okl_streams.sty_id%TYPE,
4771: contract_number okc_k_headers_b.contract_number%TYPE,
4772: currency_code okc_k_headers_b.currency_code%TYPE,
4773: authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,
4774: sty_name okl_strm_type_v.NAME%TYPE,