APPS.IGS_EN_GEN_006 dependencies on IGS_CA_TYPE

Line 143: IGS_CA_TYPE cat,

139: CURSOR c_ci1 IS
140: SELECT ci1.cal_type,
141: ci1.sequence_number
142: FROM IGS_CA_INST ci1,
143: IGS_CA_TYPE cat,
144: IGS_CA_STAT cs
145: WHERE cat.cal_type = ci1.cal_type AND
146: cat.s_cal_cat = cst_academic AND
147: ci1.cal_status = cs.cal_status AND

Line 297: FROM IGS_CA_TYPE CT,

293: SELECT CI.cal_type,
294: CI.sequence_number,
295: CI.start_dt,
296: CI.end_dt
297: FROM IGS_CA_TYPE CT,
298: IGS_CA_INST CI,
299: IGS_CA_STAT CS
300: WHERE CT.closed_ind = 'N' AND
301: CS.s_cal_status = cst_active AND

Line 651: IGS_CA_TYPE cat,

647: CURSOR c_ct_ci IS
648: SELECT ci.cal_type,
649: ci.sequence_number
650: FROM IGS_CA_INST_REL cir,
651: IGS_CA_TYPE cat,
652: IGS_CA_INST ci,
653: IGS_CA_STAT cs
654: WHERE cir.sup_cal_type = p_acad_cal_type AND
655: cir.sup_ci_sequence_number = p_acad_ci_sequence_number AND