APPS.IGS_EN_VAL_GLC SQL Statements

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

Line: 15

  		SELECT 	*
  		FROM	IGS_PE_LANGUAGE_CD
  		WHERE	govt_language_cd = p_govt_language_cd and
  			closed_ind = 'N';

Line: 20

  	-- Validate the update on a govt_language_record.
  	-- A IGS_PE_GOV_COUNTRYCD 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_LANGUAGE_CD records exist
  		OPEN  c_language_cd;