1370:
1371: l_manager_name per_all_people_f.full_name%type;
1372: cursor find_mgr_name is
1373: select mgr.full_name
1374: from per_all_assignments_f emp, per_all_people_f mgr
1375: where emp.supervisor_id = mgr.person_id
1376: and emp.person_id = p_person_id
1377: and emp.effective_start_date <= sysdate
1378: and nvl(emp.effective_end_date, sysdate + 1) > sysdate
1397:
1398: l_title per_jobs_vl.name%type;
1399: cursor find_title is
1400: select name
1401: from per_all_assignments_f emp, per_jobs_vl jobs
1402: where emp.person_id = p_person_id
1403: and emp.effective_start_date <= sysdate
1404: and nvl(emp.effective_end_date, sysdate + 1) > sysdate
1405: and emp.job_id = jobs.job_id