APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_K_LINES_B

Line 1196: FROM okc_k_lines_b cle,

1192:
1193:
1194: CURSOR c_lines IS
1195: SELECT cle.id
1196: FROM okc_k_lines_b cle,
1197: okc_line_styles_b lse,
1198: okc_subclass_top_line stl
1199: WHERE chr_id = p_source_chr_id
1200: AND cle.lse_id= lse.id

Line 1208: FROM okc_k_lines_b cle,

1204: AND lse.lse_parent_id IS NULL;
1205:
1206: CURSOR new_c_lines(p_dest_chr_id NUMBER) IS
1207: SELECT cle.id
1208: FROM okc_k_lines_b cle,
1209: okc_line_styles_b lse,
1210: okc_subclass_top_line stl
1211: WHERE chr_id = p_dest_chr_id
1212: AND cle.lse_id= lse.id

Line 6566: okc_k_lines_b cle,

6562: SELECT 'Y'
6563: FROM okc_k_headers_b CHR
6564: WHERE EXISTS (SELECT 1
6565: FROM okc_line_styles_b lse,
6566: okc_k_lines_b cle,
6567: okl_k_lines kle
6568: WHERE cle.dnz_chr_id = CHR.id
6569: AND cle.lse_id = lse.id
6570: AND cle.id = kle.id

Line 6595: okc_k_lines_b cle,

6591:
6592: CURSOR get_fin_ast_csr IS
6593: SELECT cle.id
6594: FROM okc_line_styles_b lse,
6595: okc_k_lines_b cle,
6596: okl_k_lines kle
6597: WHERE cle.dnz_chr_id = p_durv_rec.chr_id
6598: AND cle.lse_id = lse.id
6599: AND cle.id = kle.id