APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_EN_USEC_STAT_DSP_V

Line 807: IGS_EN_USEC_STAT_DSP_V ENUSECSTAT,

803: CURSOR cur_units_cart(cp_person_id NUMBER,cp_course_cd VARCHAR2,cp_load_cal_type VARCHAR2,cp_load_ci_seq_num NUMBER ) IS
804: SELECT count(*) UNITS_IN_CART
805: FROM
806: IGS_EN_SU_ATTEMPT SUA,
807: IGS_EN_USEC_STAT_DSP_V ENUSECSTAT,
808: IGS_PS_UNIT_OFR_OPT UOO
809: WHERE sua.person_id = cp_person_id
810: AND sua.course_cd = cp_course_cd
811: AND sua.uoo_id = uoo.uoo_id

Line 826: igs_en_usec_stat_dsp_v enusecstat,

822: CURSOR cur_cart_credit_pts(cp_person_id NUMBER,cp_course_cd VARCHAR2,cp_load_cal_type VARCHAR2,cp_load_ci_seq_num NUMBER ) IS
823: SELECT SUM(NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,
824: uv.enrolled_credit_points))) total_credit_points
825: FROM igs_en_su_attempt sua,
826: igs_en_usec_stat_dsp_v enusecstat,
827: igs_ps_unit_ofr_opt uoo,
828: igs_ps_usec_cps cps,
829: igs_ps_unit_ver uv
830: WHERE sua.person_id = cp_person_id AND