DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_K_LINES

Line 370: ,okl_k_lines okl

366: --Modified for bug 8533160 to not include ABANDONED assets
367: CURSOR asset_cost IS
368: select nvl(sum(okl.oec) ,0)
369: from okc_k_lines_v okc
370: ,okl_k_lines okl
371: ,okc_line_styles_v lse
372: where okc.id=okl.id
373: and okc.lse_id = lse.id
374: and lse.lty_code='FREE_FORM1'

Line 404: ,okl_k_lines okl

400:
401: CURSOR parent_line_id IS
402: select okc.id
403: from okc_k_lines_v okc
404: ,okl_k_lines okl
405: ,okc_line_styles_v lse
406: where okc.id=okl.id
407: and okc.lse_id = lse.id
408: and lse.lty_code='FREE_FORM1'

Line 413: from OKL_K_LINES KLE1,

409: and okc.chr_id = p_contract_id;
410:
411: CURSOR c_subsidy(c_contract_id IN NUMBER,c_parent_line_id IN NUMBER) IS
412: select nvl(sum(nvl(KLE1.subsidy_override_amount,KLE1.amount)),0) amount
413: from OKL_K_LINES KLE1,
414: OKC_K_LINES_B CLE1,
415: OKC_LINE_STYLES_B LS1,
416: OKL_ASSET_SUBSIDY_UV SUB,
417: OKL_SUBSIDIES_B SUBB,