APPS.IGS_EN_GEN_001 dependencies on IGS_CA_STAT

Line 52: IGS_CA_STAT

48: SELECT IGS_CA_DA_INST_V.alias_val,
49: IGS_CA_DA_INST_V.ci_sequence_number
50: FROM IGS_CA_DA_INST_V,
51: IGS_CA_INST,
52: IGS_CA_STAT
53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND

Line 58: IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND

54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND
58: IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND
59: IGS_CA_STAT.s_cal_status <> cst_planned
60: ORDER BY alias_val DESC;
61: BEGIN
62: -- this module alculates the current instance of academic period calendar

Line 59: IGS_CA_STAT.s_cal_status <> cst_planned

55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND
58: IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND
59: IGS_CA_STAT.s_cal_status <> cst_planned
60: ORDER BY alias_val DESC;
61: BEGIN
62: -- this module alculates the current instance of academic period calendar
63: -- for the nominated academic calendar type. This is determined by searching