APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_STRM_ELEMENTS

Line 26: l_bill_date okl_strm_elements.stream_element_date%type;

22: -- Bug 4520466
23: FUNCTION get_next_bill_date ( p_khr_id IN NUMBER )
24: return date IS
25:
26: l_bill_date okl_strm_elements.stream_element_date%type;
27:
28: cursor next_bill_date_csr( p_khr_id IN NUMBER ) IS
29: SELECT MIN(ste.stream_element_date)
30: FROM OKL_STRM_ELEMENTS ste,

Line 30: FROM OKL_STRM_ELEMENTS ste,

26: l_bill_date okl_strm_elements.stream_element_date%type;
27:
28: cursor next_bill_date_csr( p_khr_id IN NUMBER ) IS
29: SELECT MIN(ste.stream_element_date)
30: FROM OKL_STRM_ELEMENTS ste,
31: OKL_STREAMS stm,
32: okl_strm_type_v sty,
33: okc_k_headers_b khr,
34: OKL_K_HEADERS khl,

Line 931: OKL_STRM_ELEMENTS STE,

927: SELECT
928: opp.object_value CONTRACT_NUMBER,
929: COUNT(STE.ID) LINE_COUNT
930: FROM
931: OKL_STRM_ELEMENTS STE,
932: OKL_STREAMS STM,
933: OKL_STRM_TYPE_V STY,
934: OKL_PARALLEL_PROCESSES OPP
935: WHERE