APPS.IGS_PS_FAC_CREDT_WRKLOAD dependencies on IGS_PS_UNIT_VER_ALL

Line 236: FROM igs_ps_unit_ver_all unit,

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,
234: work_load_cp_lab,
235: work_load_other
236: FROM igs_ps_unit_ver_all unit,
237: igs_ps_unit_ofr_opt_all usec
238: WHERE unit.unit_cd = usec.unit_cd
239: AND unit.version_number = usec.version_number
240: AND usec.uoo_id = cp_n_uoo_id;

Line 300: FROM igs_ps_unit_ver_all unit,

296: CURSOR c_unit_workload (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
297: SELECT NVL(work_load_cp_lecture,-999),
298: NVL(work_load_cp_lab,-999),
299: NVL(work_load_other,-999)
300: FROM igs_ps_unit_ver_all unit,
301: igs_ps_unit_ofr_opt_all usec
302: WHERE unit.unit_cd = usec.unit_cd
303: AND unit.version_number = usec.version_number
304: AND usec.uoo_id = cp_n_uoo_id;

Line 322: -- get the workloads defined at unit level (igs_ps_unit_ver_all) as per inheritance logic.

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.
323: OPEN c_unit_workload (p_n_uoo_id);
324: FETCH c_unit_workload INTO p_n_tot_wl_lec, p_n_tot_wl_lab, p_n_tot_wl;
325: CLOSE c_unit_workload;
326: END IF;

Line 369: FROM igs_ps_unit_ver_all

365:
366: CURSOR c_workload_val (cp_c_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
367: cp_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE) IS
368: SELECT workload_val_code
369: FROM igs_ps_unit_ver_all
370: WHERE unit_cd = cp_c_unit_cd
371: AND version_number = cp_n_version_num
372: AND ovrd_wkld_val_flag = 'Y'
373: AND ROWNUM <2;

Line 375: l_c_validation_type igs_ps_unit_ver_all.workload_val_code%TYPE;

371: AND version_number = cp_n_version_num
372: AND ovrd_wkld_val_flag = 'Y'
373: AND ROWNUM <2;
374:
375: l_c_validation_type igs_ps_unit_ver_all.workload_val_code%TYPE;
376:
377: BEGIN
378: OPEN c_workload_val(p_c_unit_cd, p_n_ver_num);
379: FETCH c_workload_val INTO l_c_validation_type;