APPS.FND_OAM_USER_INFO dependencies on PER_ALL_PEOPLE_F

Line 68: per_all_people_f per

64: usr.fax
65: INTO full_name, phone, email, fax
66: FROM
67: fnd_user usr,
68: per_all_people_f per
69: WHERE
70: trunc(SYSDATE) between per.effective_start_date
71: and per.effective_end_date
72: and per.person_id = usr.employee_id

Line 126: FROM per_all_people_f

122: L_EMP_PERSON_PARTY_ID number;
123: begin
124: SELECT party_id
125: INTO l_emp_person_party_id
126: FROM per_all_people_f
127: WHERE person_id = p_employee_id
128: AND trunc(sysdate) between effective_start_date and effective_end_date
129: UNION
130: SELECT party_id

Line 131: FROM per_all_people_f p

127: WHERE person_id = p_employee_id
128: AND trunc(sysdate) between effective_start_date and effective_end_date
129: UNION
130: SELECT party_id
131: FROM per_all_people_f p
132: WHERE p.person_id = p_employee_id
133: AND p.effective_start_date = (SELECT min(p2.effective_start_date)
134: FROM per_all_people_f p2
135: WHERE p2.person_id = p.person_id)

Line 134: FROM per_all_people_f p2

130: SELECT party_id
131: FROM per_all_people_f p
132: WHERE p.person_id = p_employee_id
133: AND p.effective_start_date = (SELECT min(p2.effective_start_date)
134: FROM per_all_people_f p2
135: WHERE p2.person_id = p.person_id)
136: AND p.effective_start_date > trunc(sysdate);
137: return(L_EMP_PERSON_PARTY_ID);
138: end GET_PARTY_ID;