APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_PS_UNIT_VER

Line 603: l_unit_ver_cp igs_ps_unit_ver.enrolled_credit_points%TYPE := NULL;

599: l_dummy1 igs_he_poous_all.fte_calc_type%TYPE;
600: l_dummy2 igs_he_poous_all.fte_intensity%TYPE;
601: l_calculated_FTE igs_he_en_susa.calculated_fte%TYPE := NULL;
602: l_trn_from_crs igs_ps_ver.course_cd%TYPE := NULL;
603: l_unit_ver_cp igs_ps_unit_ver.enrolled_credit_points%TYPE := NULL;
604: l_std_annual_load igs_ps_ver.std_annual_load%TYPE := NULL;
605: l_fte_perc igs_he_fte_proprt.fte_perc%TYPE := NULL;
606: l_intm_flag BOOLEAN := FALSE ;
607: l_intm_part_days NUMBER ;

Line 709: FROM igs_ps_unit_ver_all uv,

705:
706: --get the enrolled credit points for the unit
707: CURSOR c_unit_cp (cp_uoo_id IN NUMBER) IS
708: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
709: FROM igs_ps_unit_ver_all uv,
710: igs_ps_unit_ofr_opt uoo,
711: igs_ps_usec_cps cps
712: WHERE uoo.uoo_id=cps.uoo_id(+) AND
713: uoo.unit_cd=uv.unit_cd AND