DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_SUBSIDIES_B

Line 964: from okl_subsidies_b subb,

960: kle_sub.subsidy_override_amount subsidy_override_amount, -- added for subsidy pools enhancement
961: cleb_asst.start_date asset_start_date, -- added for subsidy pools enhancement
962: cleb_asst.id asset_id -- added for subsidy pools enhancement
963: ,subb.effective_from_date effective_from_date -- added : Bug 6050165 : prasjain
964: from okl_subsidies_b subb,
965: okl_k_lines kle_sub,
966: okc_k_lines_tl clet_sub,
967: okc_k_lines_b cleb_sub,
968: okc_line_styles_b lseb_sub,

Line 998: from okl_subsidies_b sub,

994: --cursor to check subsidy applicability at line dates
995: cursor l_cle_csr (p_subsidy_id in number,
996: p_asset_cle_id in number) is
997: Select 'Y'
998: from okl_subsidies_b sub,
999: okc_k_lines_b cleb
1000: where sub.id = p_subsidy_id
1001: and cleb.id = p_asset_cle_id
1002: and TRUNC(cleb.start_date) between TRUNC(sub.effective_from_date)