813: --
814: CURSOR c_qualifications IS
815: SELECT pqt.name
816: FROM per_qualifications pq
817: ,per_qualification_types_vl pqt
818: WHERE pq.party_id = p_party_id
819: AND pq.attendance_id IS NOT NULL
820: AND pq.awarded_date IS NOT NULL
821: AND pqt.qualification_type_id = pq.qualification_type_id
820: AND pq.awarded_date IS NOT NULL
821: AND pqt.qualification_type_id = pq.qualification_type_id
822: ORDER BY pq.awarded_date DESC;
823: --
824: l_qual_title per_qualification_types_vl.name%TYPE;
825: --
826: BEGIN
827: OPEN c_qualifications;
828: FETCH c_qualifications INTO l_qual_title;