APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 134: l_prg_ver igs_en_stdnt_ps_att.version_number%TYPE;

130: eos.elgb_ovr_step_id = new_references.elgb_ovr_step_id;
131:
132: l_cur_step_cal_rec cur_step_cal%ROWTYPE;
133:
134: l_prg_ver igs_en_stdnt_ps_att.version_number%TYPE;
135: -- Cursor to check whether the passed calendar is Teaching or not
136: CURSOR cur_cal_cat(cp_cal_type VARCHAR2) IS
137: SELECT 'x'
138: FROM igs_ca_inst ci,

Line 158: CURSOR cur_coo_id (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE, cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

154: TYPE cur_sua_def IS REF CURSOR;
155:
156: -- bmerugu added for 4433428
157: -- Cursor to get the coo_id of the student.
158: CURSOR cur_coo_id (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE, cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
159: SELECT coo_id coo_id
160: FROM igs_en_stdnt_ps_att
161: WHERE person_id = cp_person_id
162: AND course_cd = cp_program_cd ;

Line 160: FROM igs_en_stdnt_ps_att

156: -- bmerugu added for 4433428
157: -- Cursor to get the coo_id of the student.
158: CURSOR cur_coo_id (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE, cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
159: SELECT coo_id coo_id
160: FROM igs_en_stdnt_ps_att
161: WHERE person_id = cp_person_id
162: AND course_cd = cp_program_cd ;
163:
164: l_attendance_type_reach BOOLEAN := TRUE;