APPS.UMX_PROXY_USER_PVT dependencies on PER_JOBS_VL

Line 11: from per_all_assignments_f passign, per_jobs_vl job

7:
8: function get_job_title(p_person_id in per_all_people_f.person_id%type) return varchar2 is
9:
10: cursor get_title is select job.name
11: from per_all_assignments_f passign, per_jobs_vl job
12: where passign.person_id = p_person_id
13: and passign.job_id = job.job_id
14: and passign.effective_start_date <= sysdate
15: and nvl(passign.effective_end_date, sysdate+1) > sysdate;

Line 17: l_title per_jobs_vl.name%type;

13: and passign.job_id = job.job_id
14: and passign.effective_start_date <= sysdate
15: and nvl(passign.effective_end_date, sysdate+1) > sysdate;
16:
17: l_title per_jobs_vl.name%type;
18: begin
19:
20: open get_title;
21: fetch get_title into l_title;

Line 72: x_job_title out NOCOPY PER_JOBS_VL.NAME%TYPE

68:
69:
70: procedure GET_EMP_DATA(p_person_id in per_all_people_f.person_id%type,
71: x_phone_number out NOCOPY PER_PHONES.PHONE_NUMBER%TYPE ,
72: x_job_title out NOCOPY PER_JOBS_VL.NAME%TYPE
73: ) IS
74:
75: begin
76: