APPS.IGS_AV_GEN_001 dependencies on IGS_PS_UNIT_VER_ALL

Line 471: igs_ps_unit_ver_all uv

467: asu.as_version_number version_number,
468: asu.exemption_institution_cd exemption_institution_cd,
469: uv.achievable_credit_points credit
470: FROM igs_av_stnd_unit_all asu,
471: igs_ps_unit_ver_all uv
472: WHERE asu.unit_cd = uv.unit_cd
473: AND asu.version_number = uv.version_number
474: AND asu.s_adv_stnd_recognition_type = 'CREDIT'
475: AND asu.s_adv_stnd_granting_status = 'GRANTED'