APPS.IGS_EN_PRC_LOAD dependencies on IGS_PS_UNIT_OFR_OPT

Line 488: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

484: v_sua_cp NUMBER;
485: v_sua_eftsu NUMBER;
486: v_trunc_eftsu NUMBER;
487: v_return_eftsu NUMBER;
488: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
489: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
490: --dummy variable to pick up audit, billing, enrolled credit points
491: --due to signature change by EN308 Billing credit hours
492: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

Line 818: FROM IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_TCH_RESP tr

814: v_eftsu_total NUMBER;
815: --modified cursor for perf bug :3712541
816: CURSOR c_tr IS
817: SELECT tr.percentage
818: FROM IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_TCH_RESP tr
819: WHERE uoo.uoo_id = p_uoo_id
820: AND NOT EXISTS ( SELECT unit_cd
821: FROM IGS_PS_TCH_RESP_OVRD
822: WHERE uoo_id = uoo.uoo_id )

Line 1462: FROM igs_ps_unit_ofr_opt uoo,

1458: FROM IGS_EN_OR_UNIT_WLST
1459: WHERE cal_type = p_load_cal_type AND
1460: closed_flag = 'N' AND
1461: org_unit_cd = (SELECT NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd)
1462: FROM igs_ps_unit_ofr_opt uoo,
1463: igs_ps_unit_ver uv
1464: WHERE uoo.uoo_id = p_uoo_id AND
1465: uv.unit_cd = uoo.unit_cd AND
1466: uv.version_number = uoo.version_number);