APPS.IGS_EN_PRC_LOAD dependencies on IGS_OR_INSTITUTION

Line 709: FROM IGS_OR_INSTITUTION ins

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
708: SELECT COUNT(*)
709: FROM IGS_OR_INSTITUTION ins
710: WHERE ins.govt_institution_cd = 3030 AND
711: local_institution_ind = 'Y';
712: BEGIN
713: -- Routine calculates the WEFTSU figure for a Student unit Attempt.

Line 747: -- Load the INSTITUTION code and the 'local' indicator from the IGS_OR_INSTITUTION

743: CLOSE c_uv_uicl;
744: RETURN 0.000;
745: END IF;
746: CLOSE c_uv_uicl;
747: -- Load the INSTITUTION code and the 'local' indicator from the IGS_OR_INSTITUTION
748: -- table.
749: IF (p_local_ins_deakin_ind IS NOT NULL) THEN
750: v_local_ins_deakin_ind := p_local_ins_deakin_ind;
751: ELSE