DBA Data[Home] [Help]

APPS.FA_SORP_REVALUATION_PKG dependencies on FA_CALENDAR_PERIODS

Line 72: , fa_calendar_periods cp

68: CURSOR c_get_period_rec (c_start_date date) IS
69: select cp.period_num
70: , fy.fiscal_year
71: from fa_fiscal_year fy
72: , fa_calendar_periods cp
73: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
74: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
75: and cp.start_date between fy.start_date and fy.end_date
76: and c_start_date between cp.start_date and cp.end_date;