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 6562: FROM okc_line_styles_b lse,

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

Line 6591: FROM okc_line_styles_b lse,

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