APPS.IGS_AD_VAL_APCS SQL Statements

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

Line: 18

                  SELECT  sasgt.step_order_applicable_ind
                  FROM    IGS_LOOKUPS_view sasgt,
                          IGS_LOOKUPS_view sast
                  WHERE   sasgt.lookup_code = sast.step_group_type AND
                          sast.lookup_code = cp_s_admission_step_type AND
                          sast.lookup_type = 'ADMISSION_STEP_TYPE' AND --2402377
                          sasgt.lookup_Type = 'ADM_STEP_GROUP_TYPE'; --2402377

Line: 64

                  SELECT  sasgt.step_order_applicable_ind
                  FROM    IGS_LOOKUPS_view sasgt,
                          IGS_LOOKUPS_view sast
                  WHERE   sasgt.lookup_code = sast.step_group_type AND
                          sast.lookup_code = cp_s_admission_step_type AND
                          sast.lookup_type = 'ADMISSION_STEP_TYPE' AND --2402377
                          sasgt.lookup_Type = 'ADM_STEP_GROUP_TYPE'; --2402377

Line: 115

  		SELECT	sast.step_type_restriction_num_ind
  		FROM	IGS_LOOKUPS_view sast
  		WHERE	sast.lookup_code = cp_s_admission_step_type  AND
  		        sast.lookup_Type = 'ADMISSION_STEP_TYPE';

Line: 162

  		SELECT	sasty.closed_ind
  		FROM	IGS_LOOKUPS_view sasty
  		WHERE	sasty.lookup_code = p_s_admission_step_type AND
  		        sasty.lookup_type = 'ADMISSION_STEP_TYPE';