APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_STRM_TYPE_B

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

148: END IF;
149: Begin
150: SELECT 'Y'
151: INTO l_billable_stream_exists
152: FROM OKL_STREAMS A, OKL_STRM_TYPE_B C WHERE A.KHR_ID=p_chr_id
153: AND EXISTS (
154: SELECT 'X' FROM OKL_STRM_ELEMENTS B
155: WHERE B.STM_ID = A.ID
156: AND B.DATE_BILLED IS NOT NULL)

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

168: If (l_orig_system_source_code = 'OKL_REBOOK') Then -- 4905142
169: Begin
170: SELECT 'Y'
171: INTO l_billable_stream_exists
172: FROM OKL_STREAMS A, OKL_STRM_TYPE_B C WHERE A.KHR_ID=l_orig_system_id1
173: AND EXISTS (
174: SELECT 'X' FROM OKL_STRM_ELEMENTS B
175: WHERE B.STM_ID = A.ID
176: AND B.DATE_BILLED IS NOT NULL)

Line 4724: FROM okl_strm_type_b stm,

4720:
4721: CURSOR strm_name_csr ( styid NUMBER ) is
4722: SELECT tl.name name,
4723: stm.stream_type_purpose
4724: FROM okl_strm_type_b stm,
4725: OKL_STRM_TYPE_TL tl
4726: WHERE tl.id = stm.id
4727: AND tl.language = 'US'
4728: AND stm.id = styid;