APPS.IGS_EN_GEN_002 dependencies on IGS_PS_ANL_LOAD

Line 627: v_cal_rec IGS_PS_ANL_LOAD.annual_load_val%TYPE;

623: -- 1.000 multiplied by the standard annual load of the first year of the
624: -- IGS_PS_COURSE.
625: DECLARE
626: v_atl_rec IGS_EN_ATD_TYPE_LOAD.default_eftsu%TYPE;
627: v_cal_rec IGS_PS_ANL_LOAD.annual_load_val%TYPE;
628: v_crv_rec IGS_PS_VER.std_annual_load%TYPE;
629: v_annual_load NUMBER;
630: CURSOR c_atl IS
631: SELECT atl.default_eftsu

Line 637: FROM IGS_PS_ANL_LOAD cal

633: WHERE atl.cal_type = p_load_cal_type AND
634: atl.attendance_type = p_attendance_type;
635: CURSOR c_cal IS
636: SELECT annual_load_val
637: FROM IGS_PS_ANL_LOAD cal
638: WHERE cal.course_cd = p_course_cd AND
639: cal.version_number = p_version_number
640: ORDER BY yr_num ASC;
641: CURSOR c_crv IS