APPS.IGS_AD_GEN_013 SQL Statements

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

Line: 288

  SELECT  apcs.s_admission_step_type
  FROM    igs_ad_prcs_cat_step apcs
  WHERE   apcs.admission_cat = p_admission_cat AND
          apcs.s_admission_process_type = p_s_admission_process_type AND
          apcs.s_admission_step_type = p_s_admission_step_type AND
          apcs.step_group_type = p_s_adm_step_group_type;

Line: 326

   SELECT system_status
   FROM   igs_ad_code_classes
   WHERE  name = p_name
   AND    class = p_class
   AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';