APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_STRM_TYPE_B

Line 162: FROM OKL_STREAMS A, OKL_STRM_TYPE_B C WHERE A.KHR_ID=p_chr_id

158: END IF;
159: Begin
160: SELECT 'Y'
161: INTO l_billable_stream_exists
162: FROM OKL_STREAMS A, OKL_STRM_TYPE_B C WHERE A.KHR_ID=p_chr_id
163: AND EXISTS (
164: SELECT 'X' FROM OKL_STRM_ELEMENTS B
165: WHERE B.STM_ID = A.ID
166: AND B.DATE_BILLED IS NOT NULL)

Line 182: FROM OKL_STREAMS A, OKL_STRM_TYPE_B C WHERE A.KHR_ID=l_orig_system_id1

178: If (l_orig_system_source_code = 'OKL_REBOOK') Then -- 4905142
179: Begin
180: SELECT 'Y'
181: INTO l_billable_stream_exists
182: FROM OKL_STREAMS A, OKL_STRM_TYPE_B C WHERE A.KHR_ID=l_orig_system_id1
183: AND EXISTS (
184: SELECT 'X' FROM OKL_STRM_ELEMENTS B
185: WHERE B.STM_ID = A.ID
186: AND B.DATE_BILLED IS NOT NULL)

Line 4821: FROM okl_strm_type_b stm,

4817:
4818: CURSOR strm_name_csr ( styid NUMBER ) is
4819: SELECT tl.name name,
4820: stm.stream_type_purpose
4821: FROM okl_strm_type_b stm,
4822: OKL_STRM_TYPE_TL tl
4823: WHERE tl.id = stm.id
4824: AND tl.language = 'US'
4825: AND stm.id = styid;