APPS.HRI_BPL_REC_PIPLN SQL Statements

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

Line: 191

  SELECT
   per_system_status            system_status
  ,assignment_status_type_id    status_id
  ,user_status                  user_status
  FROM per_assignment_status_types
  WHERE per_system_status IN
   ('ACTIVE_APL','INTERVIEW1','INTERVIEW2','OFFER','ACCEPTED','TERM_APL');