DBA Data[Home] [Help]

APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_CALENDAR_PERIODS

Line 294: FROM fa_calendar_periods

290: g_step := 'PREVIOUS PERIOD';
291:
292: SELECT period_num
293: INTO g_period_num
294: FROM fa_calendar_periods
295: WHERE calendar_type = g_calendar_type
296: AND start_date = g_current_period_from_date1;
297:
298: SELECT start_date,end_date

Line 301: FROM fa_calendar_periods

297:
298: SELECT start_date,end_date
299: INTO g_current_period_from_date2,
300: g_current_period_to_date2
301: FROM fa_calendar_periods
302: WHERE calendar_type = g_calendar_type
303: AND period_num = decode(g_period_num,1,g_number_per_fy,g_period_num-1)
304: AND end_date = g_current_period_from_date1 - 1;
305:

Line 430: FROM fa_calendar_periods

426:
427:
428: SELECT decode(g_country_code, 'CL',(start_date-1), end_date)
429: INTO l_close_date
430: FROM fa_calendar_periods
431: WHERE calendar_type = g_calendar_type
432: AND trunc(p_date) BETWEEN start_date AND end_date;
433:
434: