APPS.IGS_AS_VAL_GS SQL Statements

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

Line: 21

  		SELECT 	COUNT(*)
  		FROM 	IGS_AS_GRD_SCHEMA
  		WHERE 	grading_schema_cd = cp_grading_schema_cd AND
  			version_number <> cp_version_number AND
  			end_dt IS NULL;

Line: 69

    		SELECT	start_dt,
    			NVL(end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))
    		FROM	IGS_AS_GRD_SCHEMA
    		WHERE	grading_schema_cd = p_grading_schema_cd AND
    			version_number <> p_version_number;