APPS.IGS_AD_GEN_008 SQL Statements

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

Line: 13

		SELECT	s_adm_fee_status
		FROM	IGS_AD_FEE_STAT
		WHERE	adm_fee_status = p_adm_fee_status;

Line: 41

		SELECT	s_adm_offer_dfrmnt_status
		FROM	IGS_AD_OFRDFRMT_STAT
		WHERE	adm_offer_dfrmnt_status = p_adm_offer_dfrmnt_status;

Line: 69

		SELECT	s_adm_offer_resp_status
		FROM	IGS_AD_OFR_RESP_STAT
		WHERE	adm_offer_resp_status = p_adm_offer_resp_status;

Line: 96

		SELECT	s_adm_outcome_status
		FROM	IGS_AD_OU_STAT
		WHERE	adm_outcome_status = p_adm_outcome_status;

Line: 117

		SELECT	auos.s_adm_outcome_status
		FROM	IGS_AD_UNIT_OU_STAT		auos
		WHERE	auos.adm_unit_outcome_status = p_adm_unit_outcome_status;

Line: 152

		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_short_strt_dt_alias
		ORDER BY daiv.alias_val DESC;

Line: 341

		SELECT	aa.person_id,
			aa.adm_appl_status,
			aa.adm_fee_status,
			aa.admission_cat,
			aa.s_admission_process_type,
			aa.appl_dt,
			acaiv.adm_doc_status,
			acaiv.adm_entry_qual_status,
			acaiv.late_adm_fee_status,
			acaiv.adm_outcome_status,
			acaiv.adm_cndtnl_offer_status,
			acaiv.adm_offer_resp_status,
			acaiv.adm_offer_dfrmnt_status,
			aca.req_for_reconsideration_ind,
			acaiv.course_cd,
			acaiv.crv_version_number,
			aa.acad_cal_type,
			aa.acad_ci_sequence_number,
			acaiv.location_cd,
			acaiv.attendance_mode,
			acaiv.attendance_type,
			acaiv.adm_cal_type,
			acaiv.adm_ci_sequence_number
		FROM
			igs_ad_appl			aa,
			igs_ad_ps_appl_inst		acaiv, /* Replacing IGS_AD_PS_APPL_INST_APLINST_V with base tables Bug: 3150054 */
			igs_ad_ps_appl                  aca
		WHERE
			acaiv.person_id 		= p_person_id			AND
			acaiv.admission_appl_number	= p_admission_appl_number	AND
			acaiv.nominated_course_cd	= p_nominated_course_cd		AND
			acaiv.sequence_number		= p_acai_sequence_number	AND
			aa.person_id			= acaiv.person_id		AND
		 	aa.admission_appl_number	= acaiv.admission_appl_number   AND
			aa.person_id                    = aca.person_id               AND
			acaiv.admission_appl_number        = aca.admission_appl_number   AND
			acaiv.nominated_course_cd          = aca.nominated_course_cd;

Line: 732

		SELECT	aas.adm_appl_status
		FROM	IGS_AD_APPL_STAT aas
		WHERE	aas.s_adm_appl_status 	= p_s_adm_appl_status AND
			aas.system_default_ind  = 'Y' AND
			aas.closed_ind	        = 'N';

Line: 793

      SELECT   ci_adm.sequence_number adm_sequence_number,
               ci_acad.cal_type acad_cal_type,
               ci_acad.sequence_number acad_sequence_number,
               ci_adm.alternate_code adm_alternate_code
          FROM igs_ca_type ct_adm,
               igs_ca_inst ci_adm,
               igs_ca_stat cs,
               igs_ca_inst_rel cir,
               igs_ca_inst ci_acad,
               igs_ca_type ct_acad
         WHERE ct_adm.cal_type = cp_cal_type
           AND ct_adm.cal_type = ci_adm.cal_type
           AND SYSDATE <= ci_adm.end_dt
           AND ct_adm.s_cal_cat = 'ADMISSION'
           AND ci_adm.cal_status = cs.cal_status
           AND cs.s_cal_status = 'ACTIVE'
           AND ci_adm.cal_type = cir.sub_cal_type
           AND ci_adm.sequence_number = cir.sub_ci_sequence_number
           AND ct_acad.cal_type = ci_acad.cal_type
           AND ci_acad.cal_type = cir.sup_cal_type
           AND ci_acad.sequence_number = cir.sup_ci_sequence_number
           AND ct_acad.s_cal_cat = 'ACADEMIC'
      ORDER BY ci_adm.start_dt;

Line: 821

      SELECT inq_cal_type
        FROM igs_ad_cal_conf;