APPS.IGS_AD_GEN_007 dependencies on IGS_CA_INST

Line 92: IGS_CA_INST ci1,

88: ci2.cal_type ||
89: TO_CHAR(ci2.start_dt, 'DDMMYYYY')
90: FROM IGS_AD_APPL aa,
91: IGS_AD_PS_APPL_INST acai,
92: IGS_CA_INST ci1,
93: IGS_CA_INST ci2
94: WHERE aa.person_id = p_person_id AND
95: aa.admission_appl_number = p_admission_appl_number AND
96: acai.person_id = aa.person_id AND

Line 93: IGS_CA_INST ci2

89: TO_CHAR(ci2.start_dt, 'DDMMYYYY')
90: FROM IGS_AD_APPL aa,
91: IGS_AD_PS_APPL_INST acai,
92: IGS_CA_INST ci1,
93: IGS_CA_INST ci2
94: WHERE aa.person_id = p_person_id AND
95: aa.admission_appl_number = p_admission_appl_number AND
96: acai.person_id = aa.person_id AND
97: acai.admission_appl_number = aa.admission_appl_number AND

Line 103: FROM IGS_CA_INST_REL

99: acai.sequence_number = p_sequence_number AND
100: ci1.cal_type = aa.acad_cal_type AND
101: ci1.sequence_number = (
102: SELECT sup_ci_sequence_number
103: FROM IGS_CA_INST_REL
104: WHERE sup_cal_type = aa.acad_cal_type AND
105: sub_cal_type = acai.adm_cal_type AND
106: sub_ci_sequence_number = acai.adm_ci_sequence_number) AND
107: ci2.cal_type = acai.adm_cal_type AND