DBA Data[Home] [Help]

APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_STRM_TYPE_TL

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

1173: );
1174: */
1175: -- satya commented
1176: --AND SFE_TYPE NOT IN ('SFO'); -- smahapat added for fee type soln
1177: CURSOR l_okl_sty_name_csr(p_sty_id IN okl_strm_type_tl.id%TYPE)
1178: IS
1179: SELECT NAME
1180: FROM OKL_STRM_TYPE_TL
1181: WHERE ID = p_sty_id

Line 1180: FROM OKL_STRM_TYPE_TL

1176: --AND SFE_TYPE NOT IN ('SFO'); -- smahapat added for fee type soln
1177: CURSOR l_okl_sty_name_csr(p_sty_id IN okl_strm_type_tl.id%TYPE)
1178: IS
1179: SELECT NAME
1180: FROM OKL_STRM_TYPE_TL
1181: WHERE ID = p_sty_id
1182: AND LANGUAGE = USERENV('LANG'); -- smahapat fixed bug# 3323146
1183: CURSOR l_okl_sil_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE,
1184: