APPS.IGS_ST_VAL_GSE SQL Statements

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

Line: 15

  		SELECT	count(*)
  		FROM	IGS_ST_GVT_SPSHT_CTL	gsc
  		WHERE	gsc.submission_yr = p_submission_yr AND
  			gsc.submission_number = p_submission_number AND
  			gsc.completion_dt IS NOT NULL;

Line: 21

  	--Validate update, insert or delete of the government snapshot tables.
  	--This routine will be called from the triggers for the associated tables.
  	--Check the snapshot is complete.
  	OPEN c_gsc;