APPS.IGS_AD_VAL_TAC SQL Statements

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

Line: 14

  		SELECT	COUNT(*)
  		FROM	IGS_AD_CD
  		WHERE	tac_admission_cd = p_tac_admission_cd AND
  			closed_ind = 'N';

Line: 20

  	-- Validate the update of a IGS_AD_TAC_AD_CD 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;