APPS.UMX_PROXY_USER_PVT dependencies on PER_PHONES

Line 43: l_phone_number per_phones.phone_number%type;

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
46: from per_phones perph
47: where perph.phone_type = 'W1'

Line 46: from per_phones perph

42:
43: l_phone_number per_phones.phone_number%type;
44: cursor find_phone_number is
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

Line 71: x_phone_number out NOCOPY PER_PHONES.PHONE_NUMBER%TYPE ,

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:
75: begin