APPS.IGS_EN_NSC_PKG dependencies on IGS_CA_INST_REL

Line 256: FROM igs_ca_inst_rel

252:
253: CURSOR c_acad_term IS
254: SELECT sup_cal_type,
255: sup_ci_sequence_number
256: FROM igs_ca_inst_rel
257: WHERE sub_cal_type = l_load_cal_type
258: AND sub_ci_sequence_number = l_load_cal_seq
259: AND sup_cal_type IN
260: (SELECT cal_type

Line 2063: igs_ca_inst_rel cir

2059: ci.sequence_number
2060: FROM igs_ca_type ct,
2061: igs_ca_inst ci,
2062: igs_ca_stat cs,
2063: igs_ca_inst_rel cir
2064: WHERE ct.closed_ind = 'N' AND
2065: cs.s_cal_status = cst_active AND
2066: ci.cal_status = cs.cal_status AND
2067: ct.s_cal_cat = cst_load AND