APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_STREAMS

Line 1012: FROM OKL_STREAMS_V STM,

1008: -- RMUNJULU 09-APR-03 Changed the query to get only BILLABLE streams
1009: -- RMUNJULU 14-APR-03 2904268 Added amount > 0
1010: CURSOR get_unbill_strms_csr ( p_khr_id IN NUMBER, p_eff_from_date IN DATE) IS
1011: SELECT SEL.id
1012: FROM OKL_STREAMS_V STM,
1013: OKL_STRM_ELEMENTS_V SEL,
1014: OKC_K_HEADERS_V KHR,
1015: OKL_STRM_TYPE_B STY
1016: WHERE KHR.id = p_khr_id

Line 1038: OKL_STREAMS stm,

1034: WHERE id = p_chr_id
1035: AND EXISTS (
1036: SELECT 1
1037: FROM OKL_STRM_TYPE_B sty,
1038: OKL_STREAMS stm,
1039: OKL_STRM_ELEMENTS ste,
1040: OKL_PROD_STRM_TYPES_V psty,
1041: OKL_K_HEADERS khr
1042: WHERE stm.khr_id = chr.id