APPS.FII_NON_DBI_TIME_C SQL Statements

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

Line: 38

     select distinct gl.period_set_name, gl.period_type from gl_periods gl
     minus
     select distinct cal.period_set_name, cal.period_type from fii_time_cal_name cal;

Line: 49

   select nvl(max(calendar_id),0)
   into l_max_cal_name
   from fii_time_cal_name;

Line: 62

      insert into fii_time_cal_name
      (calendar_id,
       period_set_name,
       period_type,
       name,
       creation_date,
       last_update_date,
       last_updated_by,
       created_by,
       last_update_login)
      values(
       l_max_cal_name+1,
       new_cal_rec.period_set_name,
       new_cal_rec.period_type,
       new_cal_rec.period_set_name||' ('||new_cal_rec.period_type||')',
       sysdate,
       sysdate,
       g_user_id,
       g_user_id,
       g_login_id);