APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PER_ALL_PEOPLE_F

Line 83: per_all_people_f per,

79: SELECT per.person_id approver_id
80: from pa_resources_denorm res_denorm,
81: fnd_grants fg,
82: fnd_objects fob,
83: per_all_people_f per,
84: wf_roles wfr,
85: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
86: from dual) prmry_contact_menu
87: where fob.obj_name = 'ORGANIZATION'

Line 10239: FROM per_all_people_f per , per_person_types ppt

10235: AND assignment_id = p_assignment_id ;
10236:
10237: CURSOR get_person_type(p_person_id IN NUMBER) IS
10238: SELECT per.full_name, ppt.SYSTEM_PERSON_TYPE , ppt.USER_PERSON_TYPE
10239: FROM per_all_people_f per , per_person_types ppt
10240: where per.person_type_id = ppt.person_type_id
10241: AND per.person_id = p_person_id
10242: AND per.effective_end_date = (SELECT MAX(pf.effective_end_date)
10243: FROM per_all_people_f pf

Line 10243: FROM per_all_people_f pf

10239: FROM per_all_people_f per , per_person_types ppt
10240: where per.person_type_id = ppt.person_type_id
10241: AND per.person_id = p_person_id
10242: AND per.effective_end_date = (SELECT MAX(pf.effective_end_date)
10243: FROM per_all_people_f pf
10244: WHERE pf.person_id = p_person_id);
10245:
10246: CURSOR c_sys_status_code(l_in_status_code IN VARCHAR2 ) IS
10247: SELECT project_system_status_code