[Home] [Help]
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'
102: FROM igs_as_gpc_cls_stndg gcs
103: WHERE gcs.grading_period_cd = lp_grading_period_cd
104: AND gcs.class_standing = IGS_PR_GET_CLASS_STD.Get_Class_Standing(spa.person_id,spa.course_cd,'N',SYSDATE,lp_load_cal_type,lp_load_ci_sequence_number));
105:
106: v_dummy VARCHAR2(1);