APPS.IGS_RU_GEN_001 dependencies on IGS_PS_UNIT_OFR_OPT

Line 965: IGS_PS_UNIT_OFR_OPT uoo,

961: BEGIN
962: SELECT NVL(cps.achievable_credit_points,NVL(uv.achievable_credit_points,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)))
963: INTO l_n_credit_points
964: FROM IGS_PS_UNIT_VER uv,
965: IGS_PS_UNIT_OFR_OPT uoo,
966: IGS_PS_USEC_CPS cps
967: WHERE uoo.uoo_id=cps.uoo_id(+) AND
968: uoo.uoo_id=p_uoo_id AND
969: uoo.unit_cd = uv.unit_cd AND

Line 2797: FROM IGS_PS_UNIT_OFR_OPT A, igs_ca_inst ci

2793: FOR cur_ec IN (
2794: SELECT a.cal_type,
2795: a.ci_sequence_number,
2796: ci.start_dt
2797: FROM IGS_PS_UNIT_OFR_OPT A, igs_ca_inst ci
2798: WHERE a.unit_cd = asu.unit_cd
2799: AND a.version_number = asu.version_number
2800: AND a.cal_type = ci.cal_type
2801: AND a.ci_sequence_number = ci.sequence_number

Line 3343: FROM IGS_PS_UNIT_OFR_OPT unt_oo

3339: it will fetch all unit sections under given unit and the teach cals.
3340: */
3341: FOR uoo IN (
3342: SELECT unt_oo.cal_type,unt_oo.ci_sequence_number,unt_oo.uoo_id
3343: FROM IGS_PS_UNIT_OFR_OPT unt_oo
3344: WHERE unt_oo.unit_cd = uv.unit_cd AND
3345: unt_oo.version_number = uv.version_number
3346: ORDER BY unt_oo.cal_type, IGS_GE_NUMBER.TO_CANN(unt_oo.ci_sequence_number)
3347: )

Line 3396: FROM IGS_PS_UNIT_OFR_OPT

3392: version_number,
3393: cal_type,
3394: ci_sequence_number,
3395: uoo_id
3396: FROM IGS_PS_UNIT_OFR_OPT
3397: WHERE unit_cd = SNART.uvr_unit_cd
3398: AND version_number = SNART.uvr_version_number
3399: ORDER BY unit_cd,IGS_GE_NUMBER.TO_CANN(version_number),
3400: cal_type,IGS_GE_NUMBER.TO_CANN(ci_sequence_number) )

Line 5469: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;

5465: l_gpa_quality_points NUMBER;
5466: l_return_status VARCHAR2(30);
5467: l_msg_count NUMBER(2);
5468: l_msg_data VARCHAR2(2000);
5469: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
5470: l_best_worst VARCHAR2(3);
5471: l_recommended VARCHAR2(3);
5472:
5473: l_n_grd_set IGS_RU_SET.sequence_number%TYPE; -- Variable to hold grading schema set.