DBA Data[Home] [Help]

APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_PS_UNIT_OFR_OPT

Line 691: IGS_PS_UNIT_OFR_OPT_ALL uoo

687: sua.discontinued_dt ,
688: sua.uoo_id
689: FROM IGS_EN_SU_ATTEMPT_ALL sua,
690: IGS_HE_ST_UNT_VS_ALL hsu,
691: IGS_PS_UNIT_OFR_OPT_ALL uoo
692: WHERE sua.person_id = cp_person_id
693: AND sua.course_cd = cp_course_cd
694: AND sua.unit_cd = hsu.unit_cd (+)
695: AND sua.version_number = hsu.version_number (+)

Line 710: igs_ps_unit_ofr_opt uoo,

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
714: uoo.version_number=uv.version_number AND