APPS.IGS_AS_ADI_UPLD_UG_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 668: FROM igs_en_stdnt_ps_att spa

664: -- Get Student Program Attempt status
665: --
666: CURSOR c_spa IS
667: SELECT spa.course_attempt_status
668: FROM igs_en_stdnt_ps_att spa
669: WHERE spa.person_id = p_person_id
670: AND spa.course_cd = p_course_cd;
671: --
672: -- Get Student Unit Attempt details

Line 757: FROM igs_en_stdnt_ps_att spa,

753: FROM igs_as_gpc_programs gpr
754: WHERE gpr.course_cd = p_course_cd
755: AND gpr.grading_period_cd = p_grading_period_cd)
756: OR EXISTS ( SELECT 'X'
757: FROM igs_en_stdnt_ps_att spa,
758: igs_as_gpc_aca_stndg gas
759: WHERE spa.person_id = p_person_id
760: AND spa.course_cd = p_course_cd
761: AND spa.progression_status = gas.progression_status