APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_PR_GET_CLASS_STD

Line 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));

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);
107:
108: BEGIN