APPS.POA_TIME_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

  select min(per.start_date),
         max(per.end_date)
  from gl_periods per
  where per.period_set_name = g_period_set_name
  and per.period_type = g_period_type
  group by period_year, quarter_num
  having nvl(g_poa_fixed_date, sysdate)
  between min(per.start_date) and
          max(per.end_date);

Line: 60

  select min(per.start_date),
         max(per.end_date)
  from gl_periods per
  where per.period_set_name = g_period_set_name
  and per.period_type = g_period_type
  group by period_year, quarter_num
  having add_months(nvl(g_poa_fixed_date, sysdate), -12)
  between min(per.start_date) and
          max(per.end_date);

Line: 71

  select min(per.start_date),
         max(per.end_date)
  from gl_periods per
  where per.period_set_name = g_period_set_name
  and per.period_type = g_period_type
  group by period_year
  having nvl(g_poa_fixed_date, sysdate)
  between min(per.start_date) and
          max(per.end_date);

Line: 82

  select min(per.start_date),
         max(per.end_date)
  from gl_periods per
  where per.period_set_name = g_period_set_name
  and per.period_type = g_period_type
  group by period_year
  having add_months(nvl(g_poa_fixed_date, sysdate), -12)
  between min(per.start_date) and
          max(per.end_date);