APPS.IGS_AD_VAL_ADS SQL Statements

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

Line: 13

  		SELECT	sads.closed_ind
  		FROM	IGS_LOOKUP_VALUES sads
  		WHERE   sads.lookup_type = 'ADM_DOC_STATUS' AND
		        sads.lookup_code = p_s_adm_doc_status;

Line: 53

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_DOC_STAT ads
  		WHERE	ads.adm_doc_status <> p_adm_doc_status AND
  			ads.s_adm_doc_status = p_s_adm_doc_status AND
  			ads.system_default_ind = 'Y'
  		GROUP BY system_default_ind;