APPS.OKL_FUNDING_PVT dependencies on OKL_K_LINES

Line 2309: from OKL_K_LINES_FULL_V cle,

2305: IS
2306: select nvl(cle.AMOUNT,0),
2307: cle.id,
2308: nvl(cle.start_date,k.start_date)
2309: from OKL_K_LINES_FULL_V cle,
2310: okc_k_party_roles_b cpl,
2311: okc_line_styles_b ls,
2312: okc_k_headers_b k
2313: where k.id = cle.dnz_chr_id

Line 2357: OKL_K_LINES_FULL_V cle,

2353: --cklee end 10/3/2007 bug: 6128765
2354:
2355: from okc_rule_groups_v crg,
2356: okc_rules_v cr,
2357: OKL_K_LINES_FULL_V cle,
2358: okc_k_headers_b k
2359: where crg.dnz_chr_id = p_contract_id
2360: and cle.dnz_chr_id = k.id
2361: and crg.id = cr.rgp_id

Line 2547: from OKL_K_LINES_FULL_V cle,

2543: IS
2544: select nvl(cle.AMOUNT,0),
2545: cle.id,
2546: nvl(cle.start_date,k.start_date)
2547: from OKL_K_LINES_FULL_V cle,
2548: okc_k_party_roles_b cpl,
2549: okc_line_styles_b ls,
2550: okc_k_headers_b k
2551: where k.id = cle.dnz_chr_id

Line 2594: OKL_K_LINES_FULL_V cle,

2590: , months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))))
2591: --cklee end 10/3/2007 bug: 6128765
2592: from okc_rule_groups_v crg,
2593: okc_rules_v cr,
2594: OKL_K_LINES_FULL_V cle,
2595: okc_k_headers_b k
2596: where crg.dnz_chr_id = p_contract_id
2597: and cle.dnz_chr_id = k.id
2598: and crg.id = cr.rgp_id

Line 7115: FROM okl_k_lines lkl

7111: WHERE model_lse.ID = cle.lse_id AND model_lse.lty_code = 'ITEM' AND cle.cle_id = p_kle_id)
7112: ) -- end of model lines
7113: -- re lease flag check
7114: AND EXISTS(SELECT NULL
7115: FROM okl_k_lines lkl
7116: WHERE lkl.ID = cle.ID AND lkl.re_lease_yn IS NULL);
7117:
7118: --
7119: --

Line 7157: FROM okl_k_lines lkl

7153: WHERE mdl_parent.ID = cle.cle_id AND mdl_parent.cle_id = p_kle_id))
7154: ) -- end of add on lines
7155: -- re lease flag check
7156: AND EXISTS(SELECT NULL
7157: FROM okl_k_lines lkl
7158: WHERE lkl.ID = cle.ID AND lkl.re_lease_yn IS NULL);
7159:
7160: --
7161: --

Line 7208: FROM okl_k_lines lkl

7204: WHERE mdl_parent.ID = cle.cle_id AND mdl_parent.cle_id = p_kle_id))
7205: ) -- end of add on lines
7206: -- re lease flag check
7207: AND EXISTS(SELECT NULL
7208: FROM okl_k_lines lkl
7209: WHERE lkl.ID = cle.ID AND lkl.re_lease_yn IS NULL);
7210:
7211: --
7212: --

Line 7250: FROM okl_k_lines lkl

7246: FROM okc_k_lines_b mdl_parent
7247: WHERE mdl_parent.ID = cle.cle_id))
7248: )
7249: AND EXISTS(SELECT NULL
7250: FROM okl_k_lines lkl
7251: WHERE lkl.ID = cle.ID
7252: AND lkl.re_lease_yn IS NULL);
7253:
7254: --

Line 7260: FROM okl_k_lines

7256: CURSOR downpymnt_recvr_csr(
7257: p_kle_id NUMBER
7258: ) IS
7259: SELECT down_payment_receiver_code
7260: FROM okl_k_lines
7261: WHERE ID = p_kle_id;
7262:
7263: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;
7264: -- bug 5384359 -- end

Line 7263: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;

7259: SELECT down_payment_receiver_code
7260: FROM okl_k_lines
7261: WHERE ID = p_kle_id;
7262:
7263: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;
7264: -- bug 5384359 -- end
7265: --
7266:
7267: --start:| 08-Feb-08 cklee Fixed bug: 6783566 |

Line 7275: okl_k_lines kle_k

7271: ) IS
7272: SELECT kle.cle_id kle_id,
7273: kle_k.down_payment_receiver_code downpymnt_recvr
7274: FROM okl_assets_lov_uv kle,
7275: okl_k_lines kle_k
7276: WHERE kle.cle_id = kle_k.ID
7277: AND kle.chr_id = p_khr_id;
7278: */
7279: CURSOR c_kle_id(

Line 7284: FROM okl_k_lines kle_k,

7280: p_khr_id okc_k_headers_b.id%TYPE
7281: ) IS
7282: SELECT kle_k.id kle_id,
7283: kle_k.down_payment_receiver_code downpymnt_recvr
7284: FROM okl_k_lines kle_k,
7285: okc_k_lines_b kle
7286: where kle_k.id = kle.id
7287: and kle.dnz_chr_id = p_khr_id
7288: and kle_k.re_lease_yn IS NULL -- re lease flag check

Line 8474: from OKL_K_LINES_FULL_V cle,

8470: IS
8471: select nvl(cle.AMOUNT,0),
8472: cle.id,
8473: nvl(cle.start_date,k.start_date)
8474: from OKL_K_LINES_FULL_V cle,
8475: okc_k_party_roles_b cpl,
8476: okc_line_styles_b ls,
8477: okc_k_headers_b k
8478: where k.id = cle.dnz_chr_id

Line 8517: OKL_K_LINES_FULL_V cle,

8513: , 'S', months_between(p_effective_date, nvl(cle.start_date, k.start_date))/6
8514: , months_between(p_effective_date, nvl(cle.start_date, k.start_date))))
8515: from okc_rule_groups_v crg,
8516: okc_rules_v cr,
8517: OKL_K_LINES_FULL_V cle,
8518: okc_k_headers_b k
8519: where crg.dnz_chr_id = p_contract_id
8520: and cle.dnz_chr_id = k.id
8521: and crg.id = cr.rgp_id