APPS.IGS_EN_GEN_006 dependencies on IGS_CA_STAT

Line 144: IGS_CA_STAT cs

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
148: cs.s_cal_status = cst_active AND

Line 283: IGS_CA_STAT CS

279: cp_effective_dt IGS_CA_INST.start_dt%TYPE)IS
280: SELECT CI.cal_type,
281: CI.sequence_number
282: FROM IGS_CA_INST CI,
283: IGS_CA_STAT CS
284: WHERE CI.cal_type = cp_cal_type AND
285: CI.start_dt <= cp_effective_dt AND
286: CI.end_dt >= cp_effective_dt AND
287: CS.cal_status = CI.cal_status AND

Line 299: IGS_CA_STAT CS

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
302: CI.cal_status = CS.cal_status AND
303: CT.s_cal_cat = cst_load AND

Line 653: IGS_CA_STAT cs

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
656: cat.cal_type = cir.sub_cal_type AND
657: cat.closed_ind = 'N' AND