DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_SUBSIDIES_B

Line 734: from okl_subsidies_b subb,

730: kle_sub.subsidy_override_amount subsidy_override_amount, -- added for subsidy pools enhancement
731: cleb_asst.start_date asset_start_date, -- added for subsidy pools enhancement
732: cleb_asst.id asset_id -- added for subsidy pools enhancement
733: ,subb.effective_from_date effective_from_date -- added : Bug 6050165 : prasjain
734: from okl_subsidies_b subb,
735: okl_k_lines kle_sub,
736: okc_k_lines_tl clet_sub,
737: okc_k_lines_b cleb_sub,
738: okc_line_styles_b lseb_sub,

Line 768: from okl_subsidies_b sub,

764: --cursor to check subsidy applicability at line dates
765: cursor l_cle_csr (p_subsidy_id in number,
766: p_asset_cle_id in number) is
767: Select 'Y'
768: from okl_subsidies_b sub,
769: okc_k_lines_b cleb
770: where sub.id = p_subsidy_id
771: and cleb.id = p_asset_cle_id
772: and TRUNC(cleb.start_date) between TRUNC(sub.effective_from_date)