APPS.FND_OAM_USER_INFO dependencies on PER_ALL_PEOPLE_F

Line 62: --in per_all_people_f according to HR dev

58: IF v_employee_id > 0
59: THEN
60:
61: --9835588, work_telephone is no longer used
62: --in per_all_people_f according to HR dev
63: --and hasn't been even in 11i. Getting it from
64: --per_phones.
65:
66: SELECT

Line 73: per_all_people_f per

69: usr.fax
70: INTO full_name, email, fax
71: FROM
72: fnd_user usr,
73: per_all_people_f per
74: WHERE
75: trunc(SYSDATE) between per.effective_start_date
76: and per.effective_end_date
77: and per.person_id = usr.employee_id

Line 87: and parent_table = 'PER_ALL_PEOPLE_F'

83: select phone_number
84: into phone
85: from per_phones
86: where phone_type = 'W1'
87: and parent_table = 'PER_ALL_PEOPLE_F'
88: and sysdate between nvl(date_from, sysdate - 1)
89: and nvl(date_to, sysdate + 1)
90: and parent_id = v_employee_id;
91:

Line 148: FROM per_all_people_f

144: L_EMP_PERSON_PARTY_ID number;
145: begin
146: SELECT party_id
147: INTO l_emp_person_party_id
148: FROM per_all_people_f
149: WHERE person_id = p_employee_id
150: AND trunc(sysdate) between effective_start_date and effective_end_date
151: UNION
152: SELECT party_id

Line 153: FROM per_all_people_f p

149: WHERE person_id = p_employee_id
150: AND trunc(sysdate) between effective_start_date and effective_end_date
151: UNION
152: SELECT party_id
153: FROM per_all_people_f p
154: WHERE p.person_id = p_employee_id
155: AND p.effective_start_date = (SELECT min(p2.effective_start_date)
156: FROM per_all_people_f p2
157: WHERE p2.person_id = p.person_id)

Line 156: FROM per_all_people_f p2

152: SELECT party_id
153: FROM per_all_people_f p
154: WHERE p.person_id = p_employee_id
155: AND p.effective_start_date = (SELECT min(p2.effective_start_date)
156: FROM per_all_people_f p2
157: WHERE p2.person_id = p.person_id)
158: AND p.effective_start_date > trunc(sysdate);
159: return(L_EMP_PERSON_PARTY_ID);
160: end GET_PARTY_ID;