APPS.IGS_AS_VAL_ASST SQL Statements

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

Line: 18

  		SELECT	COUNT(*)
  		FROM	IGS_AS_ASSESSOR_TYPE
  		WHERE	dflt_ind = cst_yes AND
  			closed_ind = cst_no;

Line: 33

  	-- Check the selected data
  	IF (v_asst_count = 0) THEN
  		P_MESSAGE_NAME := 'IGS_AS_ONE_ASSESSORTYPE_DFLT';