1668: RETURN VARCHAR2 IS
1669: CURSOR l_asset_number_csr(cp_kle_id IN NUMBER) IS
1670: SELECT fat.name
1671: FROM okc_k_lines_b fa,
1672: okc_k_lines_tl fat,
1673: okc_line_styles_b stl,
1674: okc_k_lines_b top_cle,
1675: okc_line_styles_b top_stl,
1676: okc_k_lines_b sub_cle,
1688: AND fa.id = fat.id
1689: AND fat.language = USERENV('LANG')
1690: AND STL.LTY_CODE = 'FREE_FORM1'
1691: AND sub_cle.id = cp_kle_id;
1692: l_asset_number okc_k_lines_tl.name%TYPE;
1693: BEGIN
1694: OPEN l_asset_number_csr(p_kle_id);
1695: FETCH l_asset_number_csr INTO l_asset_number;
1696: CLOSE l_asset_number_csr;