APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_PS_UNIT_LEVEL_ALL

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 546: || ' igs_ps_unit_level_all lvl '

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 '
550: || ' AND sua.unit_cd = uv.unit_cd AND sua.version_number = uv.version_number '

Line 610: igs_ps_unit_level_all lvl

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
613: AND suao.person_id = sua.person_id
614: AND suao.course_cd = sua.course_cd