APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_K_LINES

Line 292: from okl_k_lines kle,

288: -------------------------------------------------------
289: Cursor l_adj_modfn_csr (p_rbk_chr_id in NUMBER,
290: p_orig_chr_id in NUMBER) is
291: select clet.name
292: from okl_k_lines kle,
293: okc_k_lines_tl clet,
294: okc_k_lines_b cleb,
295: okc_line_styles_b lseb
296: where kle.id = cleb.id

Line 306: from okl_k_lines kle2,

302: and lseb.lty_code = 'FREE_FORM1'
303: --to avoid picking up new asset during rebook
304: and cleb.orig_system_id1 is not null
305: and exists (select '1'
306: from okl_k_lines kle2,
307: okc_k_lines_b cleb2
308: where kle2.id = cleb2.id
309: and cleb2.id = nvl(cleb.orig_system_id1,-999)
310: and (

Line 965: okl_k_lines kle_sub,

961: cleb_asst.start_date asset_start_date, -- added for subsidy pools enhancement
962: cleb_asst.id asset_id -- added for subsidy pools enhancement
963: ,subb.effective_from_date effective_from_date -- added : Bug 6050165 : prasjain
964: from okl_subsidies_b subb,
965: okl_k_lines kle_sub,
966: okc_k_lines_tl clet_sub,
967: okc_k_lines_b cleb_sub,
968: okc_line_styles_b lseb_sub,
969: okc_k_lines_tl clet_asst,

Line 1046: lv_subsidy_amount okl_k_lines.amount%TYPE;

1042: -- sjalasut: added local variables for subsidy pools enhancement. START
1043: lx_sub_pool_id okl_subsidy_pools_b.id%TYPE;
1044: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
1045: l_sub_pool_applicable VARCHAR2(10);
1046: lv_subsidy_amount okl_k_lines.amount%TYPE;
1047: l_debug_enabled VARCHAR2(10);
1048: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ACTIVATE_CONTRACT_PUB.ACTIVATE_CONTRACT';
1049: is_debug_statement_on BOOLEAN;
1050: -- sjalasut: added local variables for subsidy pools enhancement. END