DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_USEC_CPS

Line 109: igs_ps_usec_cps cps

105: sua.unit_attempt_status,
106: NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)) credit_points
107: FROM igs_en_su_attempt sua,
108: igs_ps_unit_ver uv ,
109: igs_ps_usec_cps cps
110: WHERE sua.person_id = p_person_id
111: AND sua.course_cd = p_course_cd
112: AND sua.uoo_id = p_uoo_id
113: AND sua.unit_cd = uv.unit_cd

Line 2032: igs_ps_usec_cps cps

2028: NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)) override_enrolled_cp ,
2029: sua.course_cd
2030: FROM igs_en_su_attempt sua,
2031: igs_ps_unit_ver uv,
2032: igs_ps_usec_cps cps
2033: WHERE sua.person_id = p_person_id
2034: AND sua.unit_cd = uv.unit_cd
2035: AND sua.version_number = uv.version_number
2036: AND sua.unit_cd = cp_unit_cd