APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_PS_USEC_CPS

Line 828: igs_ps_usec_cps cps,

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
831: sua.course_cd = cp_course_cd AND
832: sua.uoo_id = uoo.uoo_id AND

Line 2129: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

2125: l_return_status VARCHAR2(10);
2126: l_dummy1 VARCHAR2(200);
2127: --dummy variables to pick up audit, billing, enrolled credit points
2128: --due to signature change by EN308 Billing credit hours Bug 3782329
2129: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
2130: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
2131: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
2132:
2133: BEGIN

Line 2130: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

2126: l_dummy1 VARCHAR2(200);
2127: --dummy variables to pick up audit, billing, enrolled credit points
2128: --due to signature change by EN308 Billing credit hours Bug 3782329
2129: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
2130: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
2131: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
2132:
2133: BEGIN
2134: