DBA Data[Home] [Help]

APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 64: igs_en_stdnt_ps_att spa

60: CURSOR c_sua
61: IS
62: SELECT 'X'
63: FROM igs_en_su_attempt sua,
64: igs_en_stdnt_ps_att spa
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'

Line 97: igs_en_stdnt_ps_att spa

93: CURSOR c_sua_cs
94: IS
95: SELECT 'X'
96: FROM igs_en_su_attempt sua,
97: igs_en_stdnt_ps_att spa
98: WHERE sua.uoo_id = lp_uoo_id
99: AND sua.person_id = spa.person_id
100: AND sua.course_cd = spa.course_cd
101: AND EXISTS (SELECT 'X'