APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_K_LINES_B

Line 1195: FROM okc_k_lines_b cle,

1191:
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

Line 1207: FROM okc_k_lines_b cle,

1203: AND lse.lse_parent_id IS NULL;
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

Line 6728: okc_k_lines_b cle,

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
6732: AND cle.id = kle.id

Line 6756: okc_k_lines_b cle,

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
6760: AND cle.id = kle.id

Line 9450: okc_k_lines_b cleb

9446:
9447: CURSOR c_residual_amt(p_chr_id NUMBER) IS
9448: SELECT SUM(kle.residual_value) total_residual_amount
9449: FROM okl_k_lines kle,
9450: okc_k_lines_b cleb
9451: WHERE cleb.dnz_chr_id = p_chr_id
9452: AND cleb.chr_id = p_chr_id
9453: AND kle.id = cleb.id;
9454:

Line 9475: FROM okc_k_lines_b cleb,

9471: AND txs.tax_call_type_code = 'UPFRONT_TAX';
9472:
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