APPS.IGS_AD_VAL_GBFAT SQL Statements

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

Line: 14

  		SELECT	COUNT(*)
  		FROM	IGS_AD_BASIS_FOR_AD
  		WHERE	govt_basis_for_adm_type = p_govt_basis_for_adm_type AND
  			closed_ind = 'N';

Line: 20

  	-- Validate the update of a govt_basis_for_adm_type record. A record cannot
  	-- be closed if there are records mapped onto it which are still open.
  	-- Set the default message number
  	p_message_name := null;