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 10241: FROM per_all_people_f per , per_person_types ppt

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

Line 10245: FROM per_all_people_f pf

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