APPS.IGS_PS_VAL_POSP SQL Statements

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

Line: 17

  		SELECT		cat.closed_ind,
  				cat.s_cal_cat
  		FROM		IGS_CA_TYPE		cat
  		WHERE		cat.cal_type 		= p_cal_type;

Line: 69

  		SELECT	'X'
  		FROM	IGS_CA_INST_REL	cir,
  			IGS_CA_INST			ci_sub,
  			IGS_CA_INST			ci_sup
  		WHERE	cir.sub_cal_type		= p_teach_cal_type AND
  			cir.sub_cal_type		= ci_sub.cal_type AND
  			cir.sub_ci_sequence_number	= ci_sub.sequence_number AND
  			ci_sub.end_dt			> SYSDATE AND
  			cir.sup_cal_type		= p_cal_type AND
  			cir.sup_cal_type		= ci_sup.cal_type AND
  			cir.sup_ci_sequence_number	= ci_sup.sequence_number AND
  			ci_sup.end_dt 			> SYSDATE;

Line: 135

  		SELECT	'X'
  		FROM	IGS_PS_PAT_STUDY_PRD		posp
  		WHERE	posp.course_cd 			= p_course_cd AND
  			posp.version_number		= p_version_number AND
  			posp.cal_type			= p_cal_type AND
  			posp.pos_sequence_number	= p_pos_sequence_number AND
  			(p_sequence_number  IS NULL OR
  			posp.sequence_number		<> p_sequence_number) AND
  			posp.acad_period_num		= p_acad_period_num AND
  			posp.teach_cal_type		= p_teach_cal_type;