DBA Data[Home] [Help]

APPS.IGF_DB_DISB dependencies on IGS_CA_TYPE

Line 1366: igs_ca_type ct_1,

1362: sub_cal_type tp_cal_type,
1363: sub_ci_sequence_number tp_sequence_number
1364: FROM
1365: igs_ca_inst_rel cr_1,
1366: igs_ca_type ct_1,
1367: igs_ca_type ct_2
1368: WHERE
1369: ct_1.cal_type = cr_1.sup_cal_type AND
1370: ct_1.s_cal_cat = 'ACADEMIC' AND

Line 1367: igs_ca_type ct_2

1363: sub_ci_sequence_number tp_sequence_number
1364: FROM
1365: igs_ca_inst_rel cr_1,
1366: igs_ca_type ct_1,
1367: igs_ca_type ct_2
1368: WHERE
1369: ct_1.cal_type = cr_1.sup_cal_type AND
1370: ct_1.s_cal_cat = 'ACADEMIC' AND
1371: ct_2.cal_type = cr_1.sub_cal_type AND