APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_STRM_ELEMENTS

Line 154: SELECT 'X' FROM OKL_STRM_ELEMENTS B

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)
157: AND A.STY_ID = C.ID
158: AND C.BILLABLE_YN='Y'

Line 174: SELECT 'X' FROM OKL_STRM_ELEMENTS B

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)
177: AND A.STY_ID = C.ID
178: AND C.BILLABLE_YN='Y'

Line 989: FROM OKL_STRM_ELEMENTS STE

985: CURSOR get_last_billed_due_date(
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

Line 3756: OKL_STRM_ELEMENTS STE

3752: SELECT
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

Line 3779: OKL_STRM_ELEMENTS STE

3775: SELECT
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

Line 4859: OKL_STRM_ELEMENTS STE

4855: SELECT
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