APPS.IGS_AD_VAL_AEQS SQL Statements

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

Line: 14

  		SELECT	saeqs.closed_ind
  		FROM	IGS_LOOKUP_VALUES saeqs
  		WHERE   saeqs.lookup_type = 'ADM_ENTRY_QUAL_STATUS' AND
		        saeqs.lookup_code = p_s_adm_entry_qual_status;

Line: 56

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_ENT_QF_STAT aeqs
  		WHERE	aeqs.adm_entry_qual_status <> p_adm_entry_qual_status AND
  			aeqs.s_adm_entry_qual_status = p_s_adm_entry_qual_status AND
  			aeqs.system_default_ind = 'Y'
  		GROUP BY system_default_ind;