APPS.IGS_PR_CP_GPA dependencies on IGS_AV_STND_UNIT

Line 142: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,

138: p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE);
139:
140:
141: FUNCTION chk_av_unit_ref_cd (
142: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
143: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
144: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
145: p_init_msg_list IN VARCHAR2,
146: p_return_status OUT NOCOPY VARCHAR2,

Line 873: FROM igs_av_stnd_unit asu, igs_or_inst_org_base_v inst, igs_ca_inst ci

869: asu.grading_schema_cd,
870: asu.grd_sch_version_number,
871: asu.grade,
872: asu.av_stnd_unit_id
873: FROM igs_av_stnd_unit asu, igs_or_inst_org_base_v inst, igs_ca_inst ci
874: WHERE asu.person_id = p_person_id
875: AND asu.as_course_cd = p_course_cd
876: AND asu.s_adv_stnd_granting_status IN ('GRANTED', 'APPROVED')
877: AND asu.s_adv_stnd_recognition_type = 'CREDIT'

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