APPS.IGF_SL_REL_DISB dependencies on IGS_CA_TYPE

Line 1026: FROM igs_ca_inst_rel cr_1, igs_ca_type ct_1, igs_ca_type ct_2

1022: )
1023: IS
1024: SELECT sub_cal_type tp_cal_type,
1025: sub_ci_sequence_number tp_sequence_number
1026: FROM igs_ca_inst_rel cr_1, igs_ca_type ct_1, igs_ca_type ct_2
1027: WHERE ct_1.cal_type = cr_1.sup_cal_type
1028: AND ct_1.s_cal_cat = 'ACADEMIC'
1029: AND ct_2.cal_type = cr_1.sub_cal_type
1030: AND ct_2.s_cal_cat = 'TEACHING'