APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_K_LINES

Line 6729: okl_k_lines kle

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
6733: -- START: cklee/mvasudev,10/14/2005,bug#4300891 - (okl.g Bug#4307723)

Line 6757: okl_k_lines kle

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
6761: AND lse.lty_code = 'FREE_FORM1';

Line 7704: -- the the re_lease_yn flag on okl_k_lines

7700:
7701: --Bug# 15992711: Comment the validation at contract header level
7702: -- on the re-leased asset flag.
7703: -- whether an asset is a release or new asset is determined by
7704: -- the the re_lease_yn flag on okl_k_lines
7705: /*
7706: IF( (l_fin_ast = 'Y') AND (NOT(p_durv_rec.r_larles_rule_information1 = l_lrls_yn))) THEN
7707:
7708: x_return_status := OKC_API.g_ret_sts_error;

Line 9449: FROM okl_k_lines kle,

9445: WHERE ID = p_chr_id;
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;

Line 9476: okl_k_lines kle,

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
9480: AND kle.id = cleb.id