APPS.IRC_UTILITIES_PKG dependencies on PER_QUALIFICATION_TYPES_VL

Line 802: ,per_qualification_types_vl pqt

798: --
799: CURSOR c_qualifications IS
800: SELECT pqt.name
801: FROM per_qualifications pq
802: ,per_qualification_types_vl pqt
803: WHERE pq.party_id = p_party_id
804: AND pq.attendance_id IS NOT NULL
805: AND pq.awarded_date IS NOT NULL
806: AND pqt.qualification_type_id = pq.qualification_type_id

Line 809: l_qual_title per_qualification_types_vl.name%TYPE;

805: AND pq.awarded_date IS NOT NULL
806: AND pqt.qualification_type_id = pq.qualification_type_id
807: ORDER BY pq.awarded_date DESC;
808: --
809: l_qual_title per_qualification_types_vl.name%TYPE;
810: --
811: BEGIN
812: OPEN c_qualifications;
813: FETCH c_qualifications INTO l_qual_title;