APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_K_LINES

Line 1138: okl_k_lines kle_fin

1134: */
1135: Select 'Y'
1136: from okl_subsidies_b sub,
1137: okc_k_lines_b cleb,
1138: okl_k_lines kle_fin
1139: where sub.id = p_subsidy_id
1140: and kle_fin.id = cleb.id
1141: and cleb.id = p_asset_cle_id
1142: and decode(NVL(kle_fin.re_lease_yn,'N'),

Line 3193: okl_k_lines kle_sub,

3189: null, nvl(kle_sub.AMOUNT,0),
3190: kle_sub.SUBSIDY_OVERRIDE_AMOUNT))
3191: from okc_k_lines_b cleb_sub,
3192: okc_line_styles_b lseb_sub,
3193: okl_k_lines kle_sub,
3194: okl_subsidies_b sub
3195: where kle_sub.id = cleb_sub.id And
3196: cleb_sub.lse_id = lseb_sub.id And
3197: sub.id = kle_sub.subsidy_id And

Line 3875: from okl_k_lines kle,

3871: p_subsidy_cle_id in number) is
3872: select 'Y',
3873: clet.name subsidy_name,
3874: clet_asst.name asset_number
3875: from okl_k_lines kle,
3876: okc_k_lines_tl clet,
3877: okc_k_lines_b cleb,
3878: okc_line_styles_b lseb,
3879: okc_k_lines_tl clet_asst

Line 4061: from okl_k_lines kle,

4057: p_subsidy_cle_id in number) is
4058: select 'Y',
4059: clet.name subsidy_name,
4060: clet_asst.name asset_number
4061: from okl_k_lines kle,
4062: okc_k_lines_tl clet,
4063: okc_k_lines_b cleb,
4064: okc_line_styles_b lseb,
4065: okc_k_lines_tl clet_asst

Line 4110: okl_k_lines sub_kleb

4106: subb.name
4107: from okl_subsidies_b subb,
4108: okc_k_lines_b sub_cleb,
4109: okc_line_styles_b sub_lseb,
4110: okl_k_lines sub_kleb
4111: where sub_cleb.cle_id = p_asset_cle_id
4112: and sub_cleb.sts_code <> 'ABANDONED'
4113: and sub_lseb.id = sub_cleb.lse_id
4114: and sub_lseb.lty_code = 'SUBSIDY'

Line 4126: okl_k_lines sub_kleb

4122: select count(1)
4123: from okl_subsidies_b subb,
4124: okc_k_lines_b sub_cleb,
4125: okc_line_styles_b sub_lseb,
4126: okl_k_lines sub_kleb
4127: where sub_cleb.cle_id = p_asset_cle_id
4128: and sub_cleb.sts_code <> 'ABANDONED'
4129: and sub_lseb.id = sub_cleb.lse_id
4130: and sub_lseb.lty_code = 'SUBSIDY'