APPS.PSP_WF_EFF_PKG dependencies on PER_ALL_PEOPLE_F

Line 58: FROM per_all_people_f

54: WHERE template_id = a_template_id;
55:
56: CURSOR get_emp_display_name IS
57: SELECT full_name
58: FROM per_all_people_f
59: WHERE person_id =l_person_id
60: AND effective_end_date >= l_begin_date
61: AND effective_start_date <= l_end_date
62: ORDER BY effective_start_date desc;

Line 151: In this case get the name from per_all_people_f*/

147:
148: wf_directory.GetUserName('PER', l_person_id, l_emp_username, l_emp_display_name);
149:
150: /*Bug 5145170: person name is null when he dont have any record in fnd users
151: In this case get the name from per_all_people_f*/
152:
153:
154: IF (l_emp_display_name IS NULL) THEN
155: OPEN get_emp_display_name;