APPS.IGS_AD_GEN_004 dependencies on IGS_CA_INST

Line 289: igs_ca_inst ci

285: NVL(acai.adm_cal_type, aav.adm_cal_type),
286: NVL(acai.adm_ci_sequence_number, aav.adm_ci_sequence_number)),1,10) || '/' || ci.alternate_code commencement_period
287: FROM igs_ad_ps_appl_inst acai,
288: igs_ad_appl aav,
289: igs_ca_inst ci
290: WHERE aav.person_id = acai.person_id AND
291: aav.admission_appl_number = acai.admission_appl_number AND
292: ci.cal_type = NVL(acai.adm_cal_type, aav.adm_cal_type) AND
293: ci.sequence_number = NVL(acai.adm_ci_sequence_number,aav.adm_ci_sequence_number) AND

Line 334: v_alt_acad_cal IGS_CA_INST.alternate_code%TYPE;

330: -- This module retrieves course details from IGS_AD_PS_APPL_INST
331: -- for use on letters.
332: DECLARE
333: v_out_string VARCHAR2(106) DEFAULT NULL;
334: v_alt_acad_cal IGS_CA_INST.alternate_code%TYPE;
335: CURSOR c_cv_acaiv IS
336: SELECT acaiv.preference_number,
337: acaiv.course_cd,
338: cv.short_title,

Line 349: igs_ca_inst ci1,

345: acaiv.sequence_number,
346: ci1.alternate_code || '/' || ci2.alternate_code commencement_period
347: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_APPL_ADMAPPL_V with igs_ad_appl_inst Bug: 3150054
348: igs_ad_appl aav,
349: igs_ca_inst ci1,
350: igs_ca_inst ci2,
351: igs_ps_ver cv
352: WHERE acaiv.crv_version_number = cv.version_number AND
353: acaiv.course_cd = cv.course_cd AND

Line 350: igs_ca_inst ci2,

346: ci1.alternate_code || '/' || ci2.alternate_code commencement_period
347: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_APPL_ADMAPPL_V with igs_ad_appl_inst Bug: 3150054
348: igs_ad_appl aav,
349: igs_ca_inst ci1,
350: igs_ca_inst ci2,
351: igs_ps_ver cv
352: WHERE acaiv.crv_version_number = cv.version_number AND
353: acaiv.course_cd = cv.course_cd AND
354: acaiv.person_id = p_person_id AND