APPS.OKL_LA_STREAM_PVT dependencies on OKL_STREAMS

Line 142: FROM okl_streams lsm

138: -- get the stream id
139: CURSOR l_strm_id_csr(khrid NUMBER)
140: IS
141: SELECT lsm.id
142: FROM okl_streams lsm
143: WHERE lsm.khr_id = khrid;
144: -- get the Header rule information
145: CURSOR l_hdrrl_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
146: rlcat okc_rules_b.rule_information_category%TYPE,

Line 407: okl_streams str

403: str.sgn_code sgn_code,
404: ele.stm_id stm_id,
405: ele.se_line_number se_line_number
406: FROM okl_strm_elements ele,
407: okl_streams str
408: WHERE ele.stm_id = str.id
409: AND str.khr_id = chrId
410: AND str.sty_id = styid
411: AND upper(str.say_code) = 'CURR'

Line 426: FROM okl_streams str

422: str.sgn_code sgn_code,
423: str.sgn_code alloc_yn,
424: str.comments alloc_basis,
425: str.transaction_number trn_num
426: FROM okl_streams str
427: WHERE str.say_code = status
428: AND str.khr_id = chrId
429: AND NVL(str.kle_id, -1) = kleId
430: AND str.sty_id = styId

Line 445: FROM okl_streams str

441: str.sgn_code alloc_yn,
442: str.comments alloc_basis,
443: str.transaction_number trn_num,
444: str.date_current
445: FROM okl_streams str
446: WHERE str.say_code = status
447: AND NVL(str.purpose_code,'ORIGIN') = pp
448: AND str.khr_id = chrId
449: AND (NVL( str.kle_id, -1) = -1 OR