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

6678: CURSOR chk_fin_ast_csr IS
6679: SELECT 'Y'
6680: FROM okc_k_headers_b CHR
6681: WHERE EXISTS (SELECT 1
6682: FROM okc_line_styles_b lse,
6683: okc_k_lines_b cle,
6684: okl_k_lines kle
6685: WHERE cle.dnz_chr_id = CHR.id
6686: AND cle.lse_id = lse.id

Line 6710: FROM okc_line_styles_b lse,

6706: l_lacpln_yn VARCHAR2(1) := 'X';
6707:
6708: CURSOR get_fin_ast_csr IS
6709: SELECT cle.id
6710: FROM okc_line_styles_b lse,
6711: okc_k_lines_b cle,
6712: okl_k_lines kle
6713: WHERE cle.dnz_chr_id = p_durv_rec.chr_id
6714: AND cle.lse_id = lse.id

Line 9378: okc_line_styles_b lseb

9374: CURSOR c_rvi_premium(p_chr_id NUMBER) IS
9375: SELECT kle.amount rvi_premium
9376: FROM okc_k_lines_b cleb,
9377: okl_k_lines kle,
9378: okc_line_styles_b lseb
9379: WHERE cleb.dnz_chr_id = p_chr_id
9380: AND cleb.chr_id = p_chr_id
9381: AND kle.id = cleb.id
9382: AND cleb.lse_id = lseb.id