APPS.IGS_RU_GEN_001 dependencies on IGS_AV_STND_UNIT

Line 993: FROM IGS_AV_STND_UNIT

989: -- for bug# 4480311
990: IF gv_member(p_member_index).f5 IS NULL THEN
991: SELECT SUM(nvl(achievable_credit_points,0))
992: INTO v_override_achievable_cp
993: FROM IGS_AV_STND_UNIT
994: WHERE as_course_cd = p_course_cd
995: AND person_id = p_person_id
996: AND unit_cd = gv_member(p_member_index).f1
997: AND version_number = gv_member(p_member_index).f2

Line 1120: FROM igs_av_stnd_unit av , igs_as_grd_sch_grade grad

1116: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1117:
1118: CURSOR c_grad_sch IS
1119: SELECT av.grading_schema_cd, av.grade
1120: FROM igs_av_stnd_unit av , igs_as_grd_sch_grade grad
1121: WHERE av.as_course_cd = p_course_cd
1122: AND av.person_id = p_person_id
1123: AND av.unit_cd = gv_member(p_member_index).f1
1124: AND av.version_number = gv_member(p_member_index).f2

Line 1421: FROM IGS_AV_STND_UNIT av , igs_as_grd_sch_grade grad

1417: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1418:
1419: CURSOR c_grad_sch IS
1420: SELECT av.grading_schema_cd, av.grd_sch_version_number
1421: FROM IGS_AV_STND_UNIT av , igs_as_grd_sch_grade grad
1422: WHERE av.as_course_cd = p_course_cd
1423: AND av.person_id = p_person_id
1424: AND av.unit_cd = p_tds.unit_cd
1425: AND av.version_number = p_tds.unit_version

Line 1628: v_credit_points IGS_AV_STND_UNIT_LVL.credit_points%TYPE;

1624: FUNCTION asul_attribute (
1625: p_attribute IN VARCHAR2,
1626: p_tds IN r_tds )
1627: RETURN VARCHAR2 IS
1628: v_credit_points IGS_AV_STND_UNIT_LVL.credit_points%TYPE;
1629: BEGIN
1630: IF p_attribute = 'level'
1631: THEN
1632: RETURN p_tds.unit_version;

Line 1636: FROM IGS_AV_STND_UNIT_LVL

1632: RETURN p_tds.unit_version;
1633: END IF;
1634: SELECT SUM(credit_points)
1635: INTO v_credit_points
1636: FROM IGS_AV_STND_UNIT_LVL
1637: WHERE person_id = p_person_id
1638: AND as_course_cd = p_course_cd
1639: AND s_adv_stnd_granting_status IN ('GRANTED')
1640: /*

Line 2780: FROM IGS_AV_STND_UNIT

2776: get ONE earliest calander for student to use in advanced standing set
2777: */
2778: FOR ASU IN (
2779: SELECT DISTINCT unit_cd, version_number
2780: FROM IGS_AV_STND_UNIT
2781: WHERE person_id = p_person_id
2782: AND as_course_cd = p_course_cd
2783: AND s_adv_stnd_granting_status IN ('APPROVED','GRANTED')
2784: AND s_adv_stnd_recognition_type = 'CREDIT'

Line 2833: FROM IGS_AV_STND_UNIT_LVL

2829: END IF;
2830: gv_asul_set := new_set;
2831: FOR ASUL IN (
2832: SELECT DISTINCT s_adv_stnd_type, unit_level, crs_group_ind, exemption_institution_cd
2833: FROM IGS_AV_STND_UNIT_LVL
2834: WHERE person_id = p_person_id
2835: AND as_course_cd = p_course_cd
2836: AND s_adv_stnd_granting_status IN ('GRANTED')
2837: ORDER BY s_adv_stnd_type,unit_level,crs_group_ind,exemption_institution_cd )