APPS.IGS_PS_FAC_CREDT_WRKLOAD dependencies on IGS_PS_UNIT_OFR_OPT

Line 89: igs_ps_unit_ofr_opt uoo,

85:
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

Line 232: CURSOR c_unit_workload (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

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,
234: work_load_cp_lab,
235: work_load_other
236: FROM igs_ps_unit_ver_all unit,

Line 237: igs_ps_unit_ofr_opt_all usec

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;
241:

Line 288: CURSOR c_usec_workload (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

284: Who When What
285: ***********************************************************************************************/
286:
287: -- Cursor to pick up lecture / laboratory / Other workload from unit section level
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

Line 296: CURSOR c_unit_workload (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

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
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,

Line 301: igs_ps_unit_ofr_opt_all usec

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;
305:

Line 307: CURSOR c_tr_workload(cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

303: AND unit.version_number = usec.version_number
304: AND usec.uoo_id = cp_n_uoo_id;
305:
306: -- Cursor to pick up lecture / laboratory / other workload defined at unit section teaching responsibility.
307: CURSOR c_tr_workload(cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
308: SELECT NVL(SUM (instructional_load_lecture),-999) lecture_workload,
309: NVL(SUM (instructional_load_lab),-999) laboratory_workload,
310: NVL(SUM (instructional_load),-999) other_workload
311: FROM igs_ps_usec_tch_resp

Line 366: CURSOR c_workload_val (cp_c_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

362:
363: Who When What
364: ***********************************************************************************************/
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

Line 367: cp_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE) IS

363: Who When What
364: ***********************************************************************************************/
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