DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_K_LINES

Line 333: ,okl_k_lines okl

329:
330: CURSOR asset_cost IS
331: select nvl(sum(okl.oec) ,0)
332: from okc_k_lines_v okc
333: ,okl_k_lines okl
334: ,okc_line_styles_v lse
335: where okc.id=okl.id
336: and okc.lse_id = lse.id
337: and lse.lty_code='FREE_FORM1'

Line 366: ,okl_k_lines okl

362:
363: CURSOR parent_line_id IS
364: select okc.id
365: from okc_k_lines_v okc
366: ,okl_k_lines okl
367: ,okc_line_styles_v lse
368: where okc.id=okl.id
369: and okc.lse_id = lse.id
370: and lse.lty_code='FREE_FORM1'

Line 375: from OKL_K_LINES KLE1,

371: and okc.chr_id = p_contract_id;
372:
373: CURSOR c_subsidy(c_contract_id IN NUMBER,c_parent_line_id IN NUMBER) IS
374: select nvl(sum(nvl(KLE1.subsidy_override_amount,KLE1.amount)),0) amount
375: from OKL_K_LINES KLE1,
376: OKC_K_LINES_B CLE1,
377: OKC_LINE_STYLES_B LS1,
378: OKL_ASSET_SUBSIDY_UV SUB,
379: OKL_SUBSIDIES_B SUBB,