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 437: okl_streams str

433: str.sgn_code sgn_code,
434: ele.stm_id stm_id,
435: ele.se_line_number se_line_number
436: FROM okl_strm_elements ele,
437: okl_streams str
438: WHERE ele.stm_id = str.id
439: AND str.khr_id = chrId
440: AND str.sty_id = styid
441: AND upper(str.say_code) = 'CURR'

Line 456: FROM okl_streams str

452: str.sgn_code sgn_code,
453: str.sgn_code alloc_yn,
454: str.comments alloc_basis,
455: str.transaction_number trn_num
456: FROM okl_streams str
457: WHERE str.say_code = status
458: AND str.khr_id = chrId
459: AND NVL(str.kle_id, -1) = kleId
460: AND str.sty_id = styId

Line 476: FROM OKL_STREAMS STR

472: STR.SGN_CODE ALLOC_YN,
473: STR.COMMENTS ALLOC_BASIS,
474: STR.TRANSACTION_NUMBER TRN_NUM,
475: STR.DATE_CURRENT
476: FROM OKL_STREAMS STR
477: WHERE STR.SAY_CODE = status
478: AND NVL(STR.PURPOSE_CODE,'ORIGIN') = pp
479: AND STR.KHR_ID = chrId
480: AND (

Line 501: FROM OKL_STREAMS STR

497: STR.SGN_CODE ALLOC_YN,
498: STR.COMMENTS ALLOC_BASIS,
499: STR.TRANSACTION_NUMBER TRN_NUM,
500: STR.DATE_CURRENT
501: FROM OKL_STREAMS STR
502: WHERE STR.SAY_CODE = status
503: AND NVL(STR.PURPOSE_CODE,'ORIGIN') = pp
504: AND STR.KHR_ID = chrId
505: AND STR.KLE_ID IS NULL;