APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_AS_GPC_UNIT_SETS
Line 85: igs_as_gpc_unit_sets gus
81: AND pigm.group_id = gpg.group_id
82: AND gpg.grading_period_cd = lp_grading_period_cd)
83: OR EXISTS (SELECT 'X'
84: FROM igs_as_su_setatmpt susa, 85: igs_as_gpc_unit_sets gus 86: WHERE susa.person_id = spa.person_id
87: AND susa.course_cd = spa.course_cd
88: AND (susa.end_dt is NULL
89: OR susa.rqrmnts_complete_ind = 'Y')