APPS.IGS_AV_VAL_ASU dependencies on IGS_PS_UNIT_VER

Line 1144: igs_ps_unit_ver puv

1140: asu.exemption_institution_cd,
1141: /* asu.credit_percentage, */
1142: NVL (puv.achievable_credit_points, puv.enrolled_credit_points) enrolled_cp
1143: FROM igs_av_stnd_unit asu,
1144: igs_ps_unit_ver puv
1145: WHERE asu.person_id = p_person_id
1146: AND asu.as_course_cd = p_course_cd
1147: AND asu.as_version_number = p_version_number
1148: AND asu.unit_cd = p_unit_cd

Line 1164: igs_ps_unit_ver puv

1160: asu.exemption_institution_cd,
1161: /* asu.credit_percentage, */
1162: NVL (puv.achievable_credit_points, puv.enrolled_credit_points) enrolled_cp
1163: FROM igs_av_stnd_unit asu,
1164: igs_ps_unit_ver puv
1165: WHERE asu.person_id = p_person_id
1166: AND asu.as_course_cd = p_course_cd
1167: AND asu.as_version_number = p_version_number
1168: AND asu.unit_cd = p_unit_cd

Line 1185: -- equals 100 then selects achievable credit points from igs_ps_unit_ver table.

1181: IF p_unit_details_id IS NOT NULL THEN
1182: -- if previous unit cd is not null then : 1. Checks whether credit points or credit
1183: -- percentage is null.If credit points is not null then
1184: -- selects achievable credit points from igs_av_stnd_unit table.If credit percentage
1185: -- equals 100 then selects achievable credit points from igs_ps_unit_ver table.
1186:
1187: OPEN c_adv_pre_unit;
1188: FETCH c_adv_pre_unit INTO l_adv_preunit;
1189:

Line 1206: -- equals 100 then selects achievable credit points from igs_ps_unit_ver table.

1202: ELSIF p_tst_rslt_dtls_id IS NOT NULL THEN
1203: -- if test segment is not null then : 1. Checks whether credit points or credit
1204: -- percentage is null.If credit points is not null then
1205: -- selects achievable credit points from igs_av_stnd_unit table.If credit percentage
1206: -- equals 100 then selects achievable credit points from igs_ps_unit_ver table.
1207:
1208: OPEN c_adv_test;
1209: FETCH c_adv_test INTO l_adv_test;
1210:

Line 1238: FROM igs_ps_unit_ver

1234: )
1235: RETURN VARCHAR2 AS
1236: CURSOR c_enrolled_cp IS
1237: SELECT NVL (achievable_credit_points, enrolled_credit_points) enrolled_cp
1238: FROM igs_ps_unit_ver
1239: WHERE unit_cd = p_unit_cd
1240: AND (version_number = p_version_number
1241: OR p_version_number IS NULL
1242: );

Line 1364: FROM igs_ps_unit_ver

1360: )
1361: RETURN BOOLEAN IS
1362: CURSOR c_enrolled_cp IS
1363: SELECT NVL (achievable_credit_points, enrolled_credit_points) enrolled_cp
1364: FROM igs_ps_unit_ver
1365: WHERE unit_cd = p_unit_cd
1366: AND (version_number = p_version_number
1367: OR p_version_number IS NULL
1368: );