APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_STREAMS

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 1000: , OKL_STREAMS STM

996: p_chr_id OKC_K_HEADERS_B.ID%TYPE
997: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
998: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
999: FROM OKL_STRM_ELEMENTS STE
1000: , OKL_STREAMS STM
1001: , OKL_STRM_TYPE_V STY
1002: , OKL_K_HEADERS KHR
1003: , OKC_K_HEADERS_B CHR
1004: WHERE STM.ID = STE.STM_ID

Line 3768: , OKL_STREAMS STM

3764: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3765: , STY.STYB_PURPOSE_MEANING
3766: FROM
3767: OKL_STRM_ELEMENTS STE
3768: , OKL_STREAMS STM
3769: , OKL_STRM_TYPE_V STY
3770: , OKL_K_HEADERS KHR
3771: , OKC_K_HEADERS_B CHR
3772: WHERE

Line 3792: , OKL_STREAMS STM

3788: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3789: , STY.STYB_PURPOSE_MEANING
3790: FROM
3791: OKL_STRM_ELEMENTS STE
3792: , OKL_STREAMS STM
3793: , OKL_STRM_TYPE_V STY
3794: , OKL_K_HEADERS KHR
3795: , OKC_K_HEADERS_B CHR
3796: WHERE

Line 4957: , OKL_STREAMS STM

4953: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
4954: --, STY.STYB_PURPOSE_MEANING
4955: FROM
4956: OKL_STRM_ELEMENTS STE
4957: , OKL_STREAMS STM
4958: , OKL_STRM_TYPE_V STY
4959: , OKL_K_HEADERS KHR
4960: , OKC_K_HEADERS_B CHR
4961: WHERE