APPS.IGS_PR_VAL_SCPCA SQL Statements

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

Line: 25

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

Line: 76

  		SELECT	scpc.show_cause_ind
  		FROM	IGS_PR_S_CRV_PRG_CON 		scpc
  		WHERE	scpc.course_cd		= p_course_cd AND
  			scpc.version_number 	= p_version_number;

Line: 132

  		SELECT	scpc.appeal_ind
  		FROM	IGS_PR_S_CRV_PRG_CON 		scpc
  		WHERE	scpc.course_cd		= p_course_cd AND
  			scpc.version_number 	= p_version_number;