APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_AS_GPC_PROGRAMS

Line 69: FROM igs_as_gpc_programs gpr

65: WHERE sua.uoo_id = lp_uoo_id
66: AND sua.person_id = spa.person_id
67: AND sua.course_cd = spa.course_cd
68: AND (EXISTS (SELECT 'X'
69: FROM igs_as_gpc_programs gpr
70: WHERE gpr.course_cd = spa.course_cd
71: AND gpr.course_version_number = spa.version_number
72: AND gpr.grading_period_cd = lp_grading_period_cd)
73: OR EXISTS (SELECT 'X'