APPS.IGS_AS_VAL_AIA SQL Statements

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

Line: 17

  		SELECT	closed_ind
  		FROM	IGS_AS_ASSESSOR_TYPE
  		WHERE	ass_assessor_type = cp_ass_assessor_type;

Line: 70

  		SELECT	COUNT(*)
  		FROM	IGS_AS_ITEM_ASSESSOR
  		WHERE	ass_id = cp_ass_id AND
  			person_id <> cp_person_id AND
  			primary_assessor_ind = cst_yes;

Line: 79

  		SELECT	COUNT(*)
  		FROM	IGS_AS_ITEM_ASSESSOR
  		WHERE	ass_id = cp_ass_id AND
  			person_id = cp_person_id AND
  			sequence_number <> cp_sequence_number AND
  			primary_assessor_ind = cst_no;