APPS.IGS_RE_VAL_SCH SQL Statements

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

Line: 20

  		SELECT	'x'
  		FROM	IGS_RE_SCHL_TYPE
  		WHERE	scholarship_type	= p_scholarship_type AND
  			closed_ind		= 'Y';

Line: 60

  	-- Validate that the scolarship record being created or updated
  	-- does not overlap with an existing scolarship record of the
  	-- same scolarship_type.
  DECLARE
  	v_end_dt	IGS_RE_SCHOLARSHIP.end_dt%TYPE;

Line: 68

  		SELECT	sch.start_dt,
  			sch.end_dt
  		FROM	IGS_RE_SCHOLARSHIP	sch
  		WHERE	sch.person_id		= p_person_id AND
  			sch.ca_sequence_number	= p_ca_sequence_number AND
  			sch.scholarship_type	= p_scholarship_type AND
  			sch.start_dt		<> p_start_dt;