DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_STRM_TYPE_TL

Line 56: FROM okl_strm_type_tl

52: -- Get the stream type id
53: CURSOR l_strmid_csr (strmName VARCHAR2)
54: IS
55: SELECT id styid
56: FROM okl_strm_type_tl
57: WHERE LANGUAGE = 'US'
58: AND NAME = strmName;
59: -- get the prorate convention code
60: CURSOR l_adrconv_csr (bkCode VARCHAR2,

Line 348: FROM okl_strm_type_tl tl,

344: sty.capitalize_yn capitalize_yn,
345: kle.id line_id,
346: sty.id styp_id,
347: sty.stream_type_class stream_type_class
348: FROM okl_strm_type_tl tl,
349: okl_strm_type_v sty,
350: okc_k_items cim,
351: okl_k_lines_full_v kle,
352: okc_line_styles_b ls

Line 371: okl_strm_type_tl tl

367: tl.description alloc_basis,
368: stm.capitalize_yn capitalize_yn,
369: stm.periodic_yn periodic_yn
370: FROM okl_strm_type_b stm,
371: okl_strm_type_tl tl
372: WHERE tl.id = stm.id
373: AND tl.language = 'US'
374: AND stm.id = styid;
375: -- get the install based location