APPS.OKL_RELEASE_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 1076: FROM okc_subclass_top_line stl,

1072: i number := 0;
1073:
1074: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1075: SELECT cle.id top_line
1076: FROM okc_subclass_top_line stl,
1077: okc_line_styles_b lse,
1078: okc_k_lines_b cle
1079: WHERE cle.dnz_chr_id = p_dnz_chr_id
1080: AND cle.lse_id = lse.id

Line 1299: FROM okc_subclass_top_line stl,

1295: j NUMBER := 0;
1296:
1297: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1298: SELECT cle.id top_line
1299: FROM okc_subclass_top_line stl,
1300: okc_line_styles_b lse,
1301: okc_k_lines_b cle
1302: WHERE cle.dnz_chr_id = p_dnz_chr_id
1303: AND cle.lse_id = lse.id

Line 1312: FROM okc_subclass_top_line stl,

1308: AND stl.scs_code = 'LEASE';
1309:
1310: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1311: SELECT av.asset_number asset_number
1312: FROM okc_subclass_top_line stl,
1313: okc_line_styles_b lse2,
1314: okc_line_styles_b lse1,
1315: okx_assets_v av,
1316: okc_k_items cim,