APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_K_LINES

Line 601: FROM okl_k_lines kle

597: AND rul.rule_information_category = 'LARLES'
598: AND nvl(rule_information1,'N') = 'Y');*/
599: -- Bug# 15992711 Start of Modifications
600: AND not exists ( SELECT '1'
601: FROM okl_k_lines kle
602: ,okc_k_lines_b cleb
603: WHERE cleb.dnz_chr_id = chr.id
604: AND cleb.chr_id = chr.id
605: AND cleb.id = kle.id

Line 620: FROM okl_k_lines kle

616: FROM okc_k_headers_b CHR
617: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
618: and chr.ID = p_chr_id
619: AND exists ( SELECT '1'
620: FROM okl_k_lines kle
621: ,okc_k_lines_b cleb
622: WHERE cleb.dnz_chr_id = chr.id
623: AND cleb.chr_id = chr.id
624: AND cleb.id = kle.id

Line 629: FROM okl_k_lines kle

625: AND cleb.lse_id = 33
626: AND cleb.sts_code <> 'ABANDONED'
627: AND nvl(kle.re_lease_yn,'N') = 'Y')
628: AND exists ( SELECT '1'
629: FROM okl_k_lines kle
630: ,okc_k_lines_b cleb
631: WHERE cleb.dnz_chr_id = chr.id
632: AND cleb.chr_id = chr.id
633: AND cleb.id = kle.id

Line 735: okl_k_lines kle_sub,

731: cleb_asst.start_date asset_start_date, -- added for subsidy pools enhancement
732: cleb_asst.id asset_id -- added for subsidy pools enhancement
733: ,subb.effective_from_date effective_from_date -- added : Bug 6050165 : prasjain
734: from okl_subsidies_b subb,
735: okl_k_lines kle_sub,
736: okc_k_lines_tl clet_sub,
737: okc_k_lines_b cleb_sub,
738: okc_line_styles_b lseb_sub,
739: okc_k_lines_tl clet_asst,

Line 816: lv_subsidy_amount okl_k_lines.amount%TYPE;

812: -- sjalasut: added local variables for subsidy pools enhancement. START
813: lx_sub_pool_id okl_subsidy_pools_b.id%TYPE;
814: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
815: l_sub_pool_applicable VARCHAR2(10);
816: lv_subsidy_amount okl_k_lines.amount%TYPE;
817: l_debug_enabled VARCHAR2(10);
818: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ACTIVATE_CONTRACT_PUB.ACTIVATE_CONTRACT';
819: is_debug_statement_on BOOLEAN;
820: -- sjalasut: added local variables for subsidy pools enhancement. END

Line 844: okl_k_lines kle

840: CURSOR l_chk_con_csr (chrid NUMBER) IS
841: SELECT COUNT (*)
842: FROM (SELECT COUNT(*)
843: FROM okc_k_lines_b cleb,
844: okl_k_lines kle
845: WHERE kle.id = cleb.id
846: AND cleb.chr_id = chrid
847: --ndani - 27-Mar-2013 - Bug# 16552978 - Start
848: AND cleb.dnz_chr_id = chrid

Line 859: okl_k_lines kle

855: -- cursor : to check whether Contract is having re-lease assets
856: CURSOR l_con_rel_csr (chrid NUMBER) IS
857: SELECT DISTINCT NVL(kle.re_lease_yn,'N')
858: FROM okc_k_lines_b cleb,
859: okl_k_lines kle
860: WHERE kle.id = cleb.id
861: AND cleb.chr_id = chrid
862: --ndani - 27-Mar-2013 - Bug# 16552978 - Start
863: AND cleb.dnz_chr_id = chrid

Line 869: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;

865: AND cleb.sts_code <> 'ABANDONED';
866: --ndani - 27-Mar-2013 - Bug# 16552978 - End
867:
868: l_chk_contract_count NUMBER := 0;
869: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;
870: l_acct_trans_type VARCHAR2 (256);
871: l_acc_call_rel_flag VARCHAR2 (1) := 'N';
872:
873: --Bug# 16511024 , End