APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 388: FROM igs_en_stdnt_ps_att spa

384: -- Count the number of Student Program Attempts
385: CURSOR c_count_program_reqd
386: IS
387: SELECT COUNT(*)
388: FROM igs_en_stdnt_ps_att spa
389: WHERE spa.course_attempt_status IN ('ENROLLED', 'UNCONFIRM', 'INACTIVE')
390: AND NOT EXISTS (SELECT 'X'
391: FROM igs_as_anon_id_ps anip
392: WHERE anip.person_id = spa.person_id

Line 479: FROM igs_en_stdnt_ps_att spa

475: CURSOR c_spa
476: IS
477: SELECT spa.person_id,
478: spa.course_cd
479: FROM igs_en_stdnt_ps_att spa
480: WHERE spa.course_attempt_status IN ('ENROLLED', 'UNCONFIRM','INACTIVE')
481: AND NOT EXISTS (SELECT 'X'
482: FROM igs_as_anon_id_ps anip
483: WHERE anip.person_id = spa.person_id