APPS.UMX_PROXY_USER_PVT dependencies on PER_ALL_ASSIGNMENTS_F
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;