APPS.IGS_AD_GEN_004 dependencies on IGS_AD_APPL

Line 220: igs_ad_appl aa

216: acaiv.location_cd,
217: acaiv.attendance_mode,
218: acaiv.attendance_type
219: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL Bug: 3150054
220: igs_ad_appl aa
221: WHERE acaiv.admission_appl_number = aa.admission_appl_number AND
222: acaiv.person_id = aa.person_id AND
223: acaiv.person_id = p_person_id AND
224: acaiv.admission_appl_number = p_admission_appl_number AND

Line 288: igs_ad_appl aav,

284: aav.acad_cal_type,
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

Line 347: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_APPL_ADMAPPL_V with igs_ad_appl_inst Bug: 3150054

343: aav.acad_cal_type,
344: aav.acad_ci_sequence_number,
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

Line 348: igs_ad_appl aav,

344: aav.acad_ci_sequence_number,
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