DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 1062: FROM okc_subclass_top_line stl,

1058: i number := 0;
1059:
1060: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1061: SELECT cle.id top_line
1062: FROM okc_subclass_top_line stl,
1063: okc_line_styles_b lse,
1064: okc_k_lines_b cle
1065: WHERE cle.dnz_chr_id = p_dnz_chr_id
1066: AND cle.lse_id = lse.id

Line 1278: FROM okc_subclass_top_line stl,

1274: j NUMBER := 0;
1275:
1276: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1277: SELECT cle.id top_line
1278: FROM okc_subclass_top_line stl,
1279: okc_line_styles_b lse,
1280: okc_k_lines_b cle
1281: WHERE cle.dnz_chr_id = p_dnz_chr_id
1282: AND cle.lse_id = lse.id

Line 1291: FROM okc_subclass_top_line stl,

1287: AND stl.scs_code = 'LEASE';
1288:
1289: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1290: SELECT av.asset_number asset_number
1291: FROM okc_subclass_top_line stl,
1292: okc_line_styles_b lse2,
1293: okc_line_styles_b lse1,
1294: okx_assets_v av,
1295: okc_k_items cim,