APPS.IGS_PR_CP_GPA dependencies on IGS_AV_STND_UNIT_LVL

Line 910: FROM igs_av_stnd_unit_lvl asul, igs_or_inst_org_base_v inst, igs_ca_inst ci

906: AND gsg.grade = cp_grade;
907:
908: CURSOR c_asul IS
909: SELECT SUM(NVL(asul.credit_points, 0)) sumvalue
910: FROM igs_av_stnd_unit_lvl asul, igs_or_inst_org_base_v inst, igs_ca_inst ci
911: WHERE asul.person_id = p_person_id
912: AND asul.as_course_cd = p_course_cd
913: AND asul.s_adv_stnd_granting_status IN ('GRANTED', 'APPROVED')
914: AND NVL(asul.expiry_dt, SYSDATE + 1) > SYSDATE