APPS.IGS_EN_PRC_LOAD dependencies on IGS_PS_UNIT_INT_LVL

Line 687: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE;

683: BEGIN
684: DECLARE
685: v_funding_index_1 IGS_PS_DSCP.funding_index_1%TYPE;
686: v_funding_index_2 IGS_PS_DSCP.funding_index_2%TYPE;
687: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE;
688: v_unit_level IGS_PS_UNIT_VER.unit_level%TYPE;
689: v_unit_int_course_level_cd IGS_PS_UNIT_VER.unit_int_course_level_cd%TYPE;
690: v_count NUMBER;
691: v_sua_weftsu NUMBER;

Line 703: IGS_PS_UNIT_INT_LVL uicl

699: SELECT uicl.weftsu_factor,
700: uv.unit_level,
701: uv.unit_int_course_level_cd
702: FROM IGS_PS_UNIT_VER uv,
703: IGS_PS_UNIT_INT_LVL uicl
704: WHERE uv.unit_cd = p_unit_cd AND
705: uv.version_number = p_version_number AND
706: uicl.unit_int_course_level_cd = uv.unit_int_course_level_cd;
707: CURSOR c_ins IS

Line 736: -- Load the weftsu factor, unit level and IGS_PS_UNIT_INT_LVL from

732: CLOSE c_di;
733: RETURN 0.000;
734: END IF;
735: CLOSE c_di;
736: -- Load the weftsu factor, unit level and IGS_PS_UNIT_INT_LVL from
737: -- their respective tables.
738: OPEN c_uv_uicl;
739: FETCH c_uv_uicl INTO v_weftsu_factor,
740: v_unit_level,