APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_VER_V

Line 596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;

592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
597: BEGIN
598: IF p_unit_cd IS NULL THEN
599: OPEN cur_fetch_unit_dtls(p_uoo_id);
600: FETCH cur_fetch_unit_dtls into l_unit_cd, l_unit_ver;

Line 1360: CURSOR c_unit_cp(p_unit_cd igs_ps_unit_ver.unit_cd%TYPE,p_unit_ver igs_ps_unit_ver.version_number%TYPE) IS

1356: variable_increment
1357: FROM igs_ps_usec_cps
1358: WHERE uoo_id = p_uoo_id;
1359:
1360: CURSOR c_unit_cp(p_unit_cd igs_ps_unit_ver.unit_cd%TYPE,p_unit_ver igs_ps_unit_ver.version_number%TYPE) IS
1361: SELECT
1362: POINTS_MIN ,
1363: POINTS_MAX ,
1364: points_increment

Line 1393: l_unit_ver igs_ps_unit_ver.version_number%TYPE;

1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;
1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
1391:
1392: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
1393: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
1394:
1395: l_count NUMBER(6,3) DEFAULT 0;
1396: l_return_val VARCHAR2(10000);
1397:

Line 1607: FROM igs_ps_unit_ver_v

1603: WHERE uoo_id =p_uooid;
1604: --Cursor to fetch the limits for Unit Code
1605: CURSOR cur_get_unit_maxmin_limits IS
1606: SELECT enrollment_minimum,enrollment_maximum
1607: FROM igs_ps_unit_ver_v
1608: WHERE unit_cd=p_unitcode
1609: AND version_number=p_version;
1610:
1611: BEGIN