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 4734: CURSOR c_ccid(cp_sty_id IN okl_streams.sty_id%TYPE,

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

Line 4767: kle_id okl_streams.kle_id%TYPE,

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

Line 4769: sty_id okl_streams.sty_id%TYPE,

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