APPS.IGS_EN_VAL_GCC SQL Statements

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

Line: 15

  		SELECT 	*
  		FROM	IGS_ST_CITIZENSHP_CD
  		WHERE	govt_citizenship_cd = p_govt_citizenship_cd and
  			closed_ind = 'N';

Line: 20

  	-- Validate the update on a govt_citizenshhip_record.
  	-- A IGS_PE_GOVCITIZEN_CD record cannot be closed if
  	-- there are IGS_ST_CITIZENSHP_CD records mapped to it that
  	-- are still open
  	IF (p_closed_ind = 'Y') THEN
  		-- check if open IGS_ST_CITIZENSHP_CD records exist
  		OPEN  c_citizenship_cd;