APPS.IGS_EN_GEN_001 dependencies on IGS_CA_INST

Line 51: IGS_CA_INST,

47: cp_effective_dt DATE) IS
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

Line 56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND

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
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;

Line 57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND

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
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

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 109: v_cal_type IGS_CA_INST.cal_type%TYPE;

105: p_sequence_number OUT NOCOPY NUMBER )
106: AS
107: BEGIN
108: DECLARE
109: v_cal_type IGS_CA_INST.cal_type%TYPE;
110: v_sequence_number NUMBER(6);
111: CURSOR c_sca(
112: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
113: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

Line 209: IGS_CA_INST ci

205: sua.uoo_id
206: FROM IGS_EN_SU_ATTEMPT sua,
207: IGS_PS_UNIT_VER uv,
208: IGS_PS_USEC_CPS cps,
209: IGS_CA_INST ci
210: WHERE sua.person_id = p_person_id AND
211: sua.course_cd = p_course_cd AND
212: sua.unit_attempt_status IN(cst_completed,
213: cst_duplicate) AND