APPS.IGF_AP_AWD_YR_SETUP SQL Statements

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

Line: 31

  SELECT
   SUBSTR(sys_award_year,4) code,
   award_year_status_code status,
   sys_award_year_mean
  FROM
   igf_ap_batch_aw_map_v
  WHERE
   sys_award_year like 'LI%'
  UNION
  SELECT
   '20'||SUBSTR(sys_award_year,0,2) code,
   award_year_status_code status,
   sys_award_year_mean
  FROM
   igf_ap_batch_aw_map_v
  WHERE
   Sys_award_year NOT LIKE 'LI%'
  ORDER BY 1;