DBA Data[Home] [Help]

APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_AV_ADV_STANDING_ALL

Line 481: FROM igs_av_stnd_unit_lvl_all ulvl, igs_av_adv_standing_all advstd

477: )
478: IS
479: SELECT NVL(SUM (NVL (ulvl.unit_level_mark, 0)),0) avstdmarks,
480: SUM (NVL (ulvl.credit_points, 0)) avstdcp
481: FROM igs_av_stnd_unit_lvl_all ulvl, igs_av_adv_standing_all advstd
482: WHERE ulvl.person_id = advstd.person_id
483: AND ulvl.as_course_cd = advstd.course_cd
484: AND ulvl.as_version_number = advstd.version_number
485: AND ulvl.exemption_institution_cd = advstd.exemption_institution_cd