[Home] [Help]
APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PER_PERSON_TYPES
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