APPS.IGS_EN_VAL_CNC SQL Statements

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

Line: 17

  		SELECT	IGS_PE_GOV_COUNTRYCD.closed_ind
  		FROM	IGS_PE_GOV_COUNTRYCD
  		WHERE	IGS_PE_GOV_COUNTRYCD.govt_country_cd = cp_govt_country_cd;

Line: 57

  		SELECT	person_id
  		FROM	IGS_PE_STATISTICS
  		WHERE	NVL(birth_country_cd, 'NULL') = cp_country_cd OR
  			NVL(term_location_country, 'NULL') = cp_country_cd OR
  			NVL(home_location_country, 'NULL') = cp_country_cd;