APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_K_LINES

Line 3172: okl_k_lines kle_sub,

3168: null, nvl(kle_sub.AMOUNT,0),
3169: kle_sub.SUBSIDY_OVERRIDE_AMOUNT))
3170: from okc_k_lines_b cleb_sub,
3171: okc_line_styles_b lseb_sub,
3172: okl_k_lines kle_sub,
3173: okl_subsidies_b sub
3174: where kle_sub.id = cleb_sub.id And
3175: cleb_sub.lse_id = lseb_sub.id And
3176: sub.id = kle_sub.subsidy_id And

Line 3854: from okl_k_lines kle,

3850: p_subsidy_cle_id in number) is
3851: select 'Y',
3852: clet.name subsidy_name,
3853: clet_asst.name asset_number
3854: from okl_k_lines kle,
3855: okc_k_lines_tl clet,
3856: okc_k_lines_b cleb,
3857: okc_line_styles_b lseb,
3858: okc_k_lines_tl clet_asst

Line 4040: from okl_k_lines kle,

4036: p_subsidy_cle_id in number) is
4037: select 'Y',
4038: clet.name subsidy_name,
4039: clet_asst.name asset_number
4040: from okl_k_lines kle,
4041: okc_k_lines_tl clet,
4042: okc_k_lines_b cleb,
4043: okc_line_styles_b lseb,
4044: okc_k_lines_tl clet_asst

Line 4089: okl_k_lines sub_kleb

4085: subb.name
4086: from okl_subsidies_b subb,
4087: okc_k_lines_b sub_cleb,
4088: okc_line_styles_b sub_lseb,
4089: okl_k_lines sub_kleb
4090: where sub_cleb.cle_id = p_asset_cle_id
4091: and sub_cleb.sts_code <> 'ABANDONED'
4092: and sub_lseb.id = sub_cleb.lse_id
4093: and sub_lseb.lty_code = 'SUBSIDY'

Line 4105: okl_k_lines sub_kleb

4101: select count(1)
4102: from okl_subsidies_b subb,
4103: okc_k_lines_b sub_cleb,
4104: okc_line_styles_b sub_lseb,
4105: okl_k_lines sub_kleb
4106: where sub_cleb.cle_id = p_asset_cle_id
4107: and sub_cleb.sts_code <> 'ABANDONED'
4108: and sub_lseb.id = sub_cleb.lse_id
4109: and sub_lseb.lty_code = 'SUBSIDY'