APPS.IGS_PR_VAL_PRCT SQL Statements

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

Line: 24

  		SELECT	'X'
  		FROM	IGS_CA_INST 		ci,
  			IGS_CA_STAT 		cs
  		WHERE	ci.cal_type		= p_prg_cal_type AND
  			ci.sequence_number 	= p_start_sequence_number AND
  			ci.cal_status		= cs.cal_status AND
  			cs.s_cal_status		= 'ACTIVE';

Line: 32

  		SELECT	'X'
  		FROM	IGS_CA_INST 		ci,
  			IGS_CA_STAT 		cs
  		WHERE	ci.cal_type			= p_prg_cal_type AND
  			ci.sequence_number 	= p_end_sequence_number AND
  			ci.cal_status		= cs.cal_status AND
  			cs.s_cal_status		= 'ACTIVE';

Line: 40

  		SELECT	'X'
  		FROM	IGS_CA_INST 		start_ci,
  			IGS_CA_INST 		end_ci
  		WHERE	start_ci.cal_type			= p_prg_cal_type AND
  			start_ci.sequence_number 	= p_start_sequence_number AND
  			end_ci.cal_type			= p_prg_cal_type AND
  			end_ci.sequence_number 		= p_end_sequence_number AND
  			end_ci.end_dt 			< start_ci.start_dt;