APPS.IGS_RU_GEN_001 dependencies on IGS_AV_STND_UNIT_LVL

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