APPS.IGS_AD_GEN_006 SQL Statements

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

Line: 13

		SELECT	daiv.alias_val
		FROM	IGS_CA_DA_INST_V	daiv,
			IGS_AD_CAL_CONF		sacc
		WHERE	daiv.cal_type		= p_adm_cal_type	AND
			daiv.ci_sequence_number	= p_adm_ci_sequence_number AND
			daiv.dt_alias		= sacc.adm_appl_encmb_chk_dt_alias
		ORDER BY daiv.alias_val DESC;

Line: 54

		SELECT	ppenqv.enq_acad_cal_type,
			ppenqv.enq_acad_ci_sequence_number,
			ppenqv.enq_acad_alternate_code,
			cat1.abbreviation,
			ppenqv.enq_adm_cal_type,
			ppenqv.enq_adm_ci_sequence_number,
			ppenqv.enq_adm_alternate_code,
			cat2.abbreviation
		FROM	igs_pe_person_prefs_enq_v 	ppenqv,  /* Removed cartesian join with IGS_PE_PERSON. Bug 3150054 */
			igs_ca_inst 			ci1,
			igs_ca_type 			cat1,
			igs_ca_inst 			ci2,
			igs_ca_type 			cat2
		WHERE
			ppenqv.person_id 		= p_person_id AND
			ci1.cal_type (+)		= ppenqv.enq_acad_cal_type AND
			ci1.sequence_number (+) 	= ppenqv.enq_acad_ci_sequence_number AND
			cat1.cal_type (+) 		= ci1.cal_type AND
			ci2.cal_type (+) 		= ppenqv.enq_adm_cal_type AND
			ci2.sequence_number (+) 	= ppenqv.enq_adm_ci_sequence_number AND
			cat2.cal_type (+) 		= ci2.cal_type;

Line: 118

		SELECT	itt.s_amount_type
		FROM	IGS_AD_INTAK_TRG_TYP 	itt
		WHERE	itt.intake_target_type 	= p_intake_target_type;

Line: 152

		SELECT 	agent_person_id
		FROM	IGS_PE_VISA	iv
		WHERE	person_id = p_person_id AND
			agent_person_id IS NOT NULL AND
			(visa_expiry_date > TRUNC(SYSDATE) OR
			visa_expiry_date IS NULL);

Line: 195

		SELECT	acai.offer_response_dt
		FROM	IGS_AD_PS_APPL_INST	acai
		WHERE	acai.person_id			= p_person_id AND
			acai.admission_appl_number	= p_admission_appl_number AND
			acai.nominated_course_cd	= p_nominated_course_cd AND
			acai.sequence_number		= p_acai_sequence_number;

Line: 240

		SELECT	tertiary_edu_lvl_qual
		FROM	IGS_AD_TER_ED_LVL_QF
		WHERE	tac_level_of_qual = p_tac_level_of_qual AND
			closed_ind = 'N';