DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_LINE_STYLES_V

Line 371: ,okc_line_styles_v lse

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'
375: and okc.sts_code NOT IN ('ABANDONED')

Line 405: ,okc_line_styles_v lse

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'
409: and okc.chr_id = p_contract_id;