DBA Data[Home] [Help]

APPS.IGS_ST_GEN_004 dependencies on IGS_AS_UNIT_MODE

Line 330: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;

326: v_temp_person_id NUMBER;
327: v_tmp_person_id NUMBER;
328: v_flag BOOLEAN;
329: v_prev_sub BOOLEAN;
330: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
331: v_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
332: v_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
333: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
334: v_major_course IGS_ST_GOVT_STDNT_EN.major_course%TYPE;

Line 541: IGS_AS_UNIT_MODE um

537: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
538: SELECT um.s_unit_mode
539: FROM IGS_EN_SU_ATTEMPT sua,
540: IGS_AS_UNIT_CLASS ucl,
541: IGS_AS_UNIT_MODE um
542: WHERE sua.person_id = cp_person_id AND
543: sua.course_cd = cp_course_cd AND
544: sua.unit_cd = cp_unit_cd AND
545: sua.cal_type = cp_cal_type AND