APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_STREAMS

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

986: p_chr_id OKC_K_HEADERS_B.ID%TYPE
987: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
988: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
989: FROM OKL_STRM_ELEMENTS STE
990: , OKL_STREAMS STM
991: , OKL_STRM_TYPE_V STY
992: , OKL_K_HEADERS KHR
993: , OKC_K_HEADERS_B CHR
994: WHERE STM.ID = STE.STM_ID

Line 3757: , OKL_STREAMS STM

3753: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3754: , STY.STYB_PURPOSE_MEANING
3755: FROM
3756: OKL_STRM_ELEMENTS STE
3757: , OKL_STREAMS STM
3758: , OKL_STRM_TYPE_V STY
3759: , OKL_K_HEADERS KHR
3760: , OKC_K_HEADERS_B CHR
3761: WHERE

Line 3780: , OKL_STREAMS STM

3776: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3777: , STY.STYB_PURPOSE_MEANING
3778: FROM
3779: OKL_STRM_ELEMENTS STE
3780: , OKL_STREAMS STM
3781: , OKL_STRM_TYPE_V STY
3782: , OKL_K_HEADERS KHR
3783: , OKC_K_HEADERS_B CHR
3784: WHERE

Line 4860: , OKL_STREAMS STM

4856: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
4857: --, STY.STYB_PURPOSE_MEANING
4858: FROM
4859: OKL_STRM_ELEMENTS STE
4860: , OKL_STREAMS STM
4861: , OKL_STRM_TYPE_V STY
4862: , OKL_K_HEADERS KHR
4863: , OKC_K_HEADERS_B CHR
4864: WHERE