49: FROM per_people_extra_info
50: WHERE person_id = p_person_id
51: AND information_type = 'PQH_TENURE_STATUS' ;
52:
53: /* Join with HR_LOOKUPS to get the Tenure Status Description. */
54: l_date_determine date;
55: l_adjust_date date;
56:
57: BEGIN
126: FROM per_people_extra_info
127: WHERE person_id = p_person_id
128: AND information_type = 'PQH_ACADEMIC_RANK' ;
129:
130: l_academic_rank hr_lookups.meaning%type;
131:
132: BEGIN
133: OPEN emp_rank_cur;
134: FETCH emp_rank_cur INTO l_academic_rank;