APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_PS_UNIT_LVL

Line 271: igs_ps_unit_lvl_all ul ,

267: sua.override_enrolled_cp
268: )
269: ) avail_cp
270: FROM igs_en_su_attempt_all sua,
271: igs_ps_unit_lvl_all ul ,
272: igs_ps_unit_ver_all uv
273: WHERE sua.person_id = cp_person_id
274: AND sua.course_cd = p_course_cd
275: AND NVL(sua.core_indicator_code, 'ELECTIVE') = cp_core_ind_code --Core indicator filter

Line 400: igs_ps_unit_lvl_all ul,

396: sua.override_enrolled_cp
397: )
398: ) total_cp
399: FROM igs_en_su_attempt_all sua,
400: igs_ps_unit_lvl_all ul,
401: igs_ps_unit_ver_all uv
402: WHERE sua.person_id = cp_person_id
403: AND sua.course_cd = cp_course_cd
404: AND sua.unit_cd = uv.unit_cd

Line 476: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE

472: /* jhanda */
473: CURSOR c_av_ulvl_marks (
474: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
475: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
476: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE
477: )
478: IS
479: SELECT NVL(SUM (NVL (ulvl.unit_level_mark, 0)),0) avstdmarks,
480: SUM (NVL (ulvl.credit_points, 0)) avstdcp

Line 504: || ' FROM igs_as_su_stmptout stmpt, igs_en_su_attempt sua ,IGS_PS_UNIT_LVL_ALL UL , IGS_PS_UNIT_VER_ALL UV , IGS_PS_UNIT_LEVEL_ALL LVL '

500: || ' sua.cal_type,sua.ci_sequence_number, '
501: || ' sua.uoo_id,sua.override_achievable_cp, '
502: || ' sua.override_enrolled_cp ) earned_cp, '
503: || ' NVL(ul.wam_weighting,NVL( lvl.wam_weighting,1)) wam_weight '
504: || ' FROM igs_as_su_stmptout stmpt, igs_en_su_attempt sua ,IGS_PS_UNIT_LVL_ALL UL , IGS_PS_UNIT_VER_ALL UV , IGS_PS_UNIT_LEVEL_ALL LVL '
505: || ' WHERE stmpt.person_id = :1 AND stmpt.course_cd = :2 '
506: || ' AND stmpt.person_id = sua.person_id '
507: || ' AND stmpt.course_cd = sua.course_cd '
508: || ' AND stmpt.uoo_id = sua.uoo_id '

Line 545: || ' igs_ps_unit_lvl_all ul, igs_ps_unit_ver_all uv , '

541: || ' sua.cal_type,sua.ci_sequence_number, '
542: || ' sua.uoo_id,sua.override_achievable_cp, '
543: || ' sua.override_enrolled_cp ) earned_cp '
544: || ' FROM igs_as_su_stmptout_all suao, igs_en_su_attempt_all sua, '
545: || ' igs_ps_unit_lvl_all ul, igs_ps_unit_ver_all uv , '
546: || ' igs_ps_unit_level_all lvl '
547: || ' WHERE suao.person_id = :1 AND suao.course_cd = :2 '
548: || ' AND suao.person_id= sua.person_id AND suao.course_cd = sua.course_cd '
549: || ' AND suao.uoo_id = sua.uoo_id AND NVL(sua.core_indicator_code, ''ELECTIVE'') = :3 '

Line 571: l_wam_weight igs_ps_unit_lvl.wam_weighting%TYPE;

567: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
568: l_mark NUMBER;
569: l_grade igs_as_su_stmptout_all.grade%TYPE;
570: l_earned_cp NUMBER;
571: l_wam_weight igs_ps_unit_lvl.wam_weighting%TYPE;
572: /*jhanda */
573: l_advstnd_cp NUMBER;
574:
575: -- cursor to fetch earned cp, mark and wam when there is no setup available

Line 579: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE

575: -- cursor to fetch earned cp, mark and wam when there is no setup available
576: CURSOR c_unit_lvl_mark_wo_setup (
577: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
578: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
579: cp_unit_level igs_ps_unit_lvl.unit_level%TYPE
580: )
581: IS
582: SELECT sua.unit_cd, sua.uoo_id,
583: NVL (

Line 608: igs_ps_unit_lvl_all ul,

604: )
605: earned_cp
606: FROM igs_as_su_stmptout_all suao,
607: igs_en_su_attempt_all sua,
608: igs_ps_unit_lvl_all ul,
609: igs_ps_unit_ver_all uv,
610: igs_ps_unit_level_all lvl
611: WHERE suao.person_id = cp_person_id
612: AND suao.course_cd = cp_course_cd

Line 1318: igs_ps_unit_ver_all uv, igs_ps_unit_lvl_all ul

1314: AND unit_level IS NOT NULL
1315: UNION
1316: SELECT NVL(ul.unit_level, uv.unit_level) AS unit_level, 1 AS weighted_average
1317: FROM igs_en_su_attempt_all sua ,
1318: igs_ps_unit_ver_all uv, igs_ps_unit_lvl_all ul
1319: WHERE
1320: sua.unit_cd = uv.unit_cd AND
1321: sua.version_number = uv.version_number AND
1322: sua.course_cd = ul.course_cd(+) AND