APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_STRM_ELEMENTS

Line 1001: OKL_STRM_ELEMENTS_V SEL,

997: -- RMUNJULU 14-APR-03 2904268 Added amount > 0
998: CURSOR get_unbill_strms_csr ( p_khr_id IN NUMBER, p_eff_from_date IN DATE) IS
999: SELECT SEL.id
1000: FROM OKL_STREAMS_V STM,
1001: OKL_STRM_ELEMENTS_V SEL,
1002: OKC_K_HEADERS_V KHR,
1003: OKL_STRM_TYPE_B STY
1004: WHERE KHR.id = p_khr_id
1005: AND KHR.id = STM.khr_id

Line 1027: OKL_STRM_ELEMENTS ste,

1023: AND EXISTS (
1024: SELECT 1
1025: FROM OKL_STRM_TYPE_B sty,
1026: OKL_STREAMS stm,
1027: OKL_STRM_ELEMENTS ste,
1028: OKL_PROD_STRM_TYPES_V psty,
1029: OKL_K_HEADERS khr
1030: WHERE stm.khr_id = chr.id
1031: AND khr.id = stm.khr_id