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 6563: okc_k_lines_b cle,

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

Line 6592: okc_k_lines_b cle,

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