APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_LINE_STYLES_B

Line 1197: okc_line_styles_b lse,

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
1201: AND stl.scs_code = 'LEASE'

Line 1209: okc_line_styles_b lse,

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
1213: AND stl.scs_code = 'LEASE'

Line 6565: FROM okc_line_styles_b lse,

6561: CURSOR chk_fin_ast_csr IS
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

Line 6594: FROM okc_line_styles_b lse,

6590: l_lacpln_yn VARCHAR2(1) := 'X';
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