APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PER_ALL_PEOPLE_F

Line 33: from per_all_people_f p, fnd_user f

29: l_dummy VARCHAR2(1);
30:
31: cursor get_person_id(p_user_id NUMBER) IS
32: select p.person_id
33: from per_all_people_f p, fnd_user f
34: where f.employee_id = p.person_id
35: and sysdate between p.effective_start_date and p.effective_end_date
36: and f.user_id = p_user_id;
37:

Line 893: per_all_people_f p

889:
890: cursor get_person_id IS
891: select p.person_id
892: from fnd_user f,
893: per_all_people_f p
894: where p_user_id = f.user_id
895: and f.employee_id = p.person_id
896: and sysdate between p.effective_start_date and p.effective_end_date;
897:

Line 982: per_all_people_f p

978: --Cursor to get the persion id from the user id passed to thia api
979: cursor get_person_id IS
980: select p.person_id
981: from fnd_user f,
982: per_all_people_f p
983: where p_user_id = f.user_id
984: and f.employee_id = p.person_id
985: and sysdate between p.effective_start_date and p.effective_end_date;
986:

Line 996: l_person_id per_all_people_f.person_id%TYPE;

992: where v.element_version_id = p_structure_version_id
993: and v.project_id = s.project_id
994: and v.element_version_id = s.element_version_id;
995:
996: l_person_id per_all_people_f.person_id%TYPE;
997: l_locked_person_id pa_proj_elem_ver_structure.locked_by_person_id%TYPE;
998:
999: l_module_name VARCHAR2(100) := 'pa.plsql.IS_STRUC_VER_LOCKED_BY_USER1';
1000: l_debug_mode varchar2(1);