APPS.UMX_PROXY_USER_PVT dependencies on PER_ALL_PEOPLE_F

Line 8: function get_job_title(p_person_id in per_all_people_f.person_id%type) return varchar2 is

4: /**
5: * Private function
6: */
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

Line 41: function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2 IS

37: /**
38: * Please refer to the package specifications for details
39: */
40:
41: function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
42:
43: l_phone_number per_phones.phone_number%type;
44: cursor find_phone_number is
45: select perph.phone_number

Line 49: and perph.parent_table = 'PER_ALL_PEOPLE_F'

45: select perph.phone_number
46: from per_phones perph
47: where perph.phone_type = 'W1'
48: and perph.parent_id = p_person_id
49: and perph.parent_table = 'PER_ALL_PEOPLE_F'
50: and perph.date_from <= sysdate
51: and nvl(perph.date_to, sysdate + 1) > sysdate;
52:
53:

Line 70: procedure GET_EMP_DATA(p_person_id in per_all_people_f.person_id%type,

66: * Please refer to the package specifications for details
67: */
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: