APPS.IGS_PS_FAC_CREDT_WRKLOAD dependencies on IGS_PS_USEC_CPS

Line 90: igs_ps_usec_cps cps

86: CURSOR cur_cp (cp_uoo_id IN VARCHAR2) IS
87: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
88: FROM igs_ps_unit_ver uv,
89: igs_ps_unit_ofr_opt uoo,
90: igs_ps_usec_cps cps
91: WHERE uoo.uoo_id=cps.uoo_id(+)
92: AND uoo.unit_cd=uv.unit_cd
93: AND uoo.version_number=uv.version_number
94: AND uoo.uoo_id=cp_uoo_id;

Line 229: FROM igs_ps_usec_cps uscp

225: CURSOR cur_workload IS
226: SELECT work_load_cp_lecture,
227: work_load_cp_lab,
228: work_load_other
229: FROM igs_ps_usec_cps uscp
230: WHERE uscp.uoo_id = p_uoo_id;
231:
232: CURSOR c_unit_workload (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
233: SELECT work_load_cp_lecture,

Line 292: FROM igs_ps_usec_cps uscp

288: CURSOR c_usec_workload (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
289: SELECT NVL(work_load_cp_lecture,-999),
290: NVL(work_load_cp_lab,-999),
291: NVL(work_load_other,-999)
292: FROM igs_ps_usec_cps uscp
293: WHERE uscp.uoo_id = cp_n_uoo_id;
294:
295: -- Cursor to pick up lecture / laboratory / Other workload from unit section level
296: CURSOR c_unit_workload (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

Line 318: -- get the workloads defined at unit section level (igs_ps_usec_cps).

314:
315: rec_tr_workload c_tr_workload%ROWTYPE;
316:
317: BEGIN
318: -- get the workloads defined at unit section level (igs_ps_usec_cps).
319: OPEN c_usec_workload (p_n_uoo_id);
320: FETCH c_usec_workload INTO p_n_tot_wl_lec, p_n_tot_wl_lab, p_n_tot_wl;
321: IF c_usec_workload%NOTFOUND THEN
322: -- get the workloads defined at unit level (igs_ps_unit_ver_all) as per inheritance logic.