APPS.IGS_AD_VAL_CRS_ADMPERD SQL Statements

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

Line: 27

  		SELECT	cs.s_course_status,
  			cv.expiry_dt,
  			cv.generic_course_ind,
  			ct.govt_course_type
  		FROM	IGS_PS_VER	cv,
  			IGS_PS_STAT	cs,
  			IGS_PS_TYPE	ct
  		WHERE	course_cd 	= cp_course_cd AND
  			version_number 	= cp_version_number AND
  			cv.course_status 	= cs.course_status AND
  			cv.course_type 	= ct.course_type;

Line: 103

  		SELECT	location_cd,
  			attendance_mode,
  			attendance_type
  		FROM	IGS_PS_OF_OPT_AD_CAT
  		WHERE	course_cd 	= p_course_cd AND
  			version_number 	= p_version_number AND
  			cal_type 	= p_cal_type AND
  			admission_cat 	= p_admission_cat;

Line: 174

  		SELECT	'x'
  		FROM	IGS_AD_PRD_PS_OF_OPT apcoo
  		WHERE	apcoo.adm_cal_type		= cp_adm_cal_type AND
  			apcoo.adm_ci_sequence_number	= cp_adm_ci_sequence_number AND
  			apcoo.admission_cat		= cp_admission_cat AND
  			apcoo.s_admission_process_type	= cp_s_admission_process_type;

Line: 190

  		SELECT	apcoo.location_cd,
  			apcoo.attendance_mode,
  			apcoo.attendance_type
  		FROM	IGS_AD_PRD_PS_OF_OPT apcoo
  		WHERE	apcoo.adm_cal_type		= cp_adm_cal_type AND
  			apcoo.adm_ci_sequence_number	= cp_adm_ci_sequence_number AND
  			apcoo.admission_cat		= cp_admission_cat AND
  			apcoo.s_admission_process_type	= cp_s_admission_process_type AND
  			apcoo.course_cd			= cp_course_cd AND
  			apcoo.version_number		= cp_version_number AND
  			apcoo.acad_cal_type		= cp_acad_cal_type;