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 6683: okc_k_lines_b cle,

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

Line 6711: okc_k_lines_b cle,

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

Line 9351: okc_k_lines_b cleb

9347:
9348: CURSOR c_residual_amt(p_chr_id NUMBER) IS
9349: SELECT SUM(kle.residual_value) total_residual_amount
9350: FROM okl_k_lines kle,
9351: okc_k_lines_b cleb
9352: WHERE cleb.dnz_chr_id = p_chr_id
9353: AND cleb.chr_id = p_chr_id
9354: AND kle.id = cleb.id;
9355:

Line 9376: FROM okc_k_lines_b cleb,

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