eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_PS_UNIT_VER_ALL

Line 272: igs_ps_unit_ver_all uv

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
276: AND sua.unit_cd = uv.unit_cd

Line 401: igs_ps_unit_ver_all uv

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
405: AND sua.version_number = uv.version_number

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 609: igs_ps_unit_ver_all uv,

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

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