APPS.IGS_EN_VAL_GATC SQL Statements

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

Line: 15

  		SELECT 	*
  		FROM	IGS_PE_ABORG_TORESCD
  		WHERE	govt_aborig_torres_cd = p_govt_aborig_torres_cd and
  			closed_ind = 'N';

Line: 20

  	-- Validate the update on a govt_aborig_torres_cd record.
  	-- A IGS_PE_GOV_ABRGRESCD record cannot be closed if
  	-- there are IGS_PE_LANGUAGE_CD records mapped to it that
  	-- are still open
  	IF (p_closed_ind = 'Y') THEN
  		-- check if open IGS_PE_ABORG_TORESCD records exist
  		OPEN  c_aborig_torres_cd;