APPS.IGS_EN_VAL_GPRC SQL Statements

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

Line: 15

  		SELECT 	*
  		FROM	IGS_PE_PERM_RES_CD
  		WHERE	govt_perm_resident_cd = p_govt_perm_resident_cd and
  			closed_ind = 'N';

Line: 20

  	-- Validate the update on a IGS_PE_GOV_PER_RESCD record.
  	-- A IGS_PE_GOV_PER_RESCD 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_PERM_RES_CD records exist
  		OPEN  c_perm_resident_cd;