[Home] [Help]
20: BEGIN
21: OPEN emp_cur;
22: FETCH emp_cur INTO p_employee_number,p_full_name, p_last_name, l_title, p_email_addr, p_start_date;
23: CLOSE emp_cur;
24: p_title := hr_general.decode_lookup(p_lookup_type => 'TITLE',p_lookup_code => l_title);
25: exception
26: when others then
27: p_employee_number := null;
28: p_full_name := null;
121:
122: FUNCTION getPersonRank (p_person_id IN NUMBER ) RETURN VARCHAR2 IS
123:
124: CURSOR emp_rank_cur IS
125: SELECT hr_general.decode_lookup('PQH_ACADEMIC_RANK',pei_information1)
126: FROM per_people_extra_info
127: WHERE person_id = p_person_id
128: AND information_type = 'PQH_ACADEMIC_RANK' ;
129:
156: OPEN prim_asg;
157: FETCH prim_asg INTO l_assignment_id,l_job_id,l_position_id;
158: CLOSE prim_asg;
159: if l_position_id is not null then
160: l_position_name := hr_general.decode_position_latest_name(l_position_id);
161: elsif l_job_id is not null then
162: l_job_name := hr_general.decode_job(l_job_id);
163: end if;
164: RETURN nvl(l_job_name,l_position_name);
158: CLOSE prim_asg;
159: if l_position_id is not null then
160: l_position_name := hr_general.decode_position_latest_name(l_position_id);
161: elsif l_job_id is not null then
162: l_job_name := hr_general.decode_job(l_job_id);
163: end if;
164: RETURN nvl(l_job_name,l_position_name);
165: END;
166:
302: FROM per_all_assignments_f
303: WHERE SYSDATE BETWEEN effective_start_date AND effective_end_date
304: and primary_flag ='Y'
305: -- 2005/08/08: NS: Performance fix: fetch the count for the business group
306: and business_group_id = hr_general.get_business_group_id
307: and assignment_type ='E';
308:
309: /* Faculty count of Tenured/Tenure-track status in final year of consideration*/
310: CURSOR prsn_tt_cnt_cur IS