APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_LINE_STYLES_B

Line 1196: okc_line_styles_b lse,

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

Line 1208: okc_line_styles_b lse,

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

Line 6727: FROM okc_line_styles_b lse,

6723: CURSOR chk_fin_ast_csr IS
6724: SELECT 'Y'
6725: FROM okc_k_headers_b CHR
6726: WHERE EXISTS (SELECT 1
6727: FROM okc_line_styles_b lse,
6728: okc_k_lines_b cle,
6729: okl_k_lines kle
6730: WHERE cle.dnz_chr_id = CHR.id
6731: AND cle.lse_id = lse.id

Line 6755: FROM okc_line_styles_b lse,

6751: l_lacpln_yn VARCHAR2(1) := 'X';
6752:
6753: CURSOR get_fin_ast_csr IS
6754: SELECT cle.id
6755: FROM okc_line_styles_b lse,
6756: okc_k_lines_b cle,
6757: okl_k_lines kle
6758: WHERE cle.dnz_chr_id = p_durv_rec.chr_id
6759: AND cle.lse_id = lse.id

Line 9477: okc_line_styles_b lseb

9473: CURSOR c_rvi_premium(p_chr_id NUMBER) IS
9474: SELECT kle.amount rvi_premium
9475: FROM okc_k_lines_b cleb,
9476: okl_k_lines kle,
9477: okc_line_styles_b lseb
9478: WHERE cleb.dnz_chr_id = p_chr_id
9479: AND cleb.chr_id = p_chr_id
9480: AND kle.id = cleb.id
9481: AND cleb.lse_id = lseb.id