DBA Data[Home] [Help]

APPS.FA_REVALUATION_PVT dependencies on FA_CALENDAR_PERIODS

Line 2104: FROM fa_fiscal_year fy, fa_calendar_periods cp

2100: l_period_num := -1;
2101:
2102: SELECT fy.fiscal_year, cp.period_num
2103: INTO l_fy, l_period_num
2104: FROM fa_fiscal_year fy, fa_calendar_periods cp
2105: WHERE fy.fiscal_year_name = l_fy_name
2106: AND cp.calendar_type = l_deprn_calendar
2107: AND p_asset_fin_rec_old.prorate_date BETWEEN cp.start_date
2108: AND cp.end_date