APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_K_LINES_TL

Line 1634: okc_k_lines_tl fat,

1630: RETURN VARCHAR2 IS
1631: CURSOR l_asset_number_csr(cp_kle_id IN NUMBER) IS
1632: SELECT fat.name
1633: FROM okc_k_lines_b fa,
1634: okc_k_lines_tl fat,
1635: okc_line_styles_b stl,
1636: okc_k_lines_b top_cle,
1637: okc_line_styles_b top_stl,
1638: okc_k_lines_b sub_cle,

Line 1654: l_asset_number okc_k_lines_tl.name%TYPE;

1650: AND fa.id = fat.id
1651: AND fat.language = USERENV('LANG')
1652: AND STL.LTY_CODE = 'FREE_FORM1'
1653: AND sub_cle.id = cp_kle_id;
1654: l_asset_number okc_k_lines_tl.name%TYPE;
1655: BEGIN
1656: OPEN l_asset_number_csr(p_kle_id);
1657: FETCH l_asset_number_csr INTO l_asset_number;
1658: CLOSE l_asset_number_csr;