APPS.IGS_AD_VAL_ACA SQL Statements

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

Line: 31

  		SELECT	sct.transfer_course_cd
  		FROM 	IGS_PS_STDNT_TRN sct
  		WHERE	sct.person_id 		= p_person_id AND
  			(sct.course_cd 		= p_course_cd OR
  			sct.transfer_course_cd 	= p_course_cd)
  		ORDER BY transfer_dt desc;

Line: 38

  		SELECT 	sca.course_cd
  		FROM	IGS_EN_STDNT_PS_ATT	sca,
  			IGS_PS_STDNT_TRN	sct
  		WHERE	sct.person_id 		= p_person_id AND
  			sct.course_cd 		= p_course_cd AND
  			sca.person_id 		= sct.person_id AND
  			sca.course_cd		= sct.transfer_course_cd;

Line: 47

  		SELECT 	'X'
  		FROM 	IGS_PS_STDNT_TRN sct,
  			IGS_EN_STDNT_PS_ATT sca
  		WHERE 	sct.person_id 		= p_person_id AND
  			sct.transfer_course_cd 	= cp_transfer_course_cd AND
  			(sct.course_cd 		<> p_course_cd) AND
  			sca.person_id 		= sct.person_id AND
  			sca.course_cd 		= sct.course_cd AND
  			sca.course_attempt_status IN (
  						cst_enrolled,
  						cst_inactive,
  						cst_intermit,
  						cst_lapsed);

Line: 151

  		SELECT	COUNT(*)
  		FROM	IGS_AD_PS_APPL_INST	acai
  		WHERE	acai.person_id			= cp_person_id AND
  			acai.admission_appl_number	= cp_admission_appl_number AND
  			NOT (acai.nominated_course_cd	= cp_nominated_course_cd AND
  			acai.sequence_number		= cp_sequence_number);

Line: 241

  		SELECT	generic_course_ind
  		FROM	IGS_PS_VER
  		WHERE	course_cd	= p_nominated_course_cd	AND
  			version_number	= p_nominated_version_number;

Line: 246

  		SELECT	course_attempt_status,
  			version_number
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id	= p_person_id AND
  			course_cd	= p_transfer_course_cd;

Line: 253

  		SELECT	cgr.course_group_cd
  		FROM	IGS_PS_GRP_MBR	cgm,
  			IGS_PS_GRP		cgr,
  			IGS_PS_GRP_TYPE	cgt
  		WHERE	cgm.course_cd		= p_transfer_course_cd	AND
  			cgm.version_number	= cp_version_number	AND
  			cgm.course_group_cd	= cgr.course_group_cd	AND
  			cgr.course_group_type	= cgt.course_group_type	AND
  			cgt.s_course_group_type	= 'ADMTRANSFR';

Line: 265

  		SELECT	'x'
  		FROM	IGS_PS_GRP_MBR
  		WHERE	course_cd	= cp_course_cd		AND
  			version_number	= cp_version_number	AND
  			course_group_cd	= cp_course_group_cd;

Line: 393

  		SELECT	closed_ind
  		FROM	IGS_AD_CD
  		WHERE	admission_cd = cp_admission_cd;

Line: 434

  		SELECT	bfa.closed_ind
  		FROM	IGS_AD_BASIS_FOR_AD	bfa
  		WHERE	bfa.basis_for_admission_type = p_basis_for_admission_type;