[Home] [Help]
996: AND unit_cd = gv_member(p_member_index).f1
997: AND version_number = gv_member(p_member_index).f2
998: AND s_adv_stnd_granting_status IN ('APPROVED','GRANTED')
999: AND s_adv_stnd_recognition_type = 'CREDIT'
1000: AND (igs_av_val_asu.granted_adv_standing(person_id,as_course_cd,as_version_number,unit_cd,version_number,'BOTH',NULL) ='TRUE');
1001:
1002:
1003: RETURN v_override_achievable_cp;
1004:
1123: AND av.unit_cd = gv_member(p_member_index).f1
1124: AND av.version_number = gv_member(p_member_index).f2
1125: AND av.s_adv_stnd_granting_status IN ('APPROVED','GRANTED')
1126: AND av.s_adv_stnd_recognition_type = 'CREDIT'
1127: AND (igs_av_val_asu.granted_adv_standing(av.person_id,av.as_course_cd,av.as_version_number,av.unit_cd,av.version_number,'BOTH',NULL) ='TRUE')
1128: AND grad.grading_schema_cd = av.grading_schema_cd
1129: AND grad.version_number = av.grd_sch_version_number
1130: AND grad.grade = av.grade
1131: ORDER BY grad.rank ASC;
1424: AND av.unit_cd = p_tds.unit_cd
1425: AND av.version_number = p_tds.unit_version
1426: AND av.s_adv_stnd_granting_status IN ('APPROVED','GRANTED')
1427: AND av.s_adv_stnd_recognition_type = 'CREDIT'
1428: AND (igs_av_val_asu.granted_adv_standing(av.person_id,av.as_course_cd,av.as_version_number,av.unit_cd,av.version_number,'BOTH',NULL) ='TRUE')
1429: AND grad.grading_schema_cd = av.grading_schema_cd
1430: AND grad.version_number = av.grd_sch_version_number
1431: AND grad.grade = av.grade
1432: ORDER BY grad.rank ASC;
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'
2785: AND (igs_av_val_asu.granted_adv_standing(person_id,as_course_cd,as_version_number,
2786: unit_cd,version_number,'BOTH',NULL) ='TRUE')
2787: ORDER BY unit_cd,IGS_GE_NUMBER.TO_CANN(version_number) )
2788: LOOP
2789: /*