DBA Data[Home] [Help]

APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_STRM_TYPE_TL

Line 1306: CURSOR l_okl_sty_name_csr(p_sty_id IN okl_strm_type_tl.id%TYPE)

1302: );
1303: */
1304: -- satya commented
1305: --AND SFE_TYPE NOT IN ('SFO'); -- smahapat added for fee type soln
1306: CURSOR l_okl_sty_name_csr(p_sty_id IN okl_strm_type_tl.id%TYPE)
1307: IS
1308: SELECT NAME
1309: FROM OKL_STRM_TYPE_TL
1310: WHERE ID = p_sty_id

Line 1309: FROM OKL_STRM_TYPE_TL

1305: --AND SFE_TYPE NOT IN ('SFO'); -- smahapat added for fee type soln
1306: CURSOR l_okl_sty_name_csr(p_sty_id IN okl_strm_type_tl.id%TYPE)
1307: IS
1308: SELECT NAME
1309: FROM OKL_STRM_TYPE_TL
1310: WHERE ID = p_sty_id
1311: AND LANGUAGE = USERENV('LANG'); -- smahapat fixed bug# 3323146
1312: CURSOR l_okl_sil_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE,
1313: