APPS.IGS_EN_VAL_SCT dependencies on IGS_CA_INST

Line 44: IGS_CA_INST ci

40: SELECT scae.cal_type,
41: scae.ci_sequence_number,
42: scae.enrolment_cat
43: FROM IGS_AS_SC_ATMPT_ENR scae,
44: IGS_CA_INST ci
45: WHERE scae.person_id = p_person_id AND
46: scae.course_cd = p_course_cd AND
47: scae.cal_type = ci.cal_type AND
48: scae.ci_sequence_number = ci.sequence_number

Line 112: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;

108: -- their enrolled course academic calendar type.
109: -- This is the result of a change of course offering option calendar type
110: -- during a course transfer.
111: DECLARE
112: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
113: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
114: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
115: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
116: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 113: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

109: -- This is the result of a change of course offering option calendar type
110: -- during a course transfer.
111: DECLARE
112: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
113: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
114: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
115: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
116: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
117: v_message_name varchar2(30);

Line 114: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;

110: -- during a course transfer.
111: DECLARE
112: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
113: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
114: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
115: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
116: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
117: v_message_name varchar2(30);
118: CURSOR c_sua IS

Line 115: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

111: DECLARE
112: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
113: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
114: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
115: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
116: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
117: v_message_name varchar2(30);
118: CURSOR c_sua IS
119: SELECT sua.cal_type,

Line 116: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

112: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
113: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
114: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
115: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
116: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
117: v_message_name varchar2(30);
118: CURSOR c_sua IS
119: SELECT sua.cal_type,
120: sua.ci_sequence_number