DBA Data[Home] [Help]

APPS.WIP_WS_SKILL_CHECK_PVT dependencies on PER_ALL_PEOPLE_F

Line 47: from per_all_people_f

43: where wip_entity_id = p_wip_entity_id;
44:
45: select full_name
46: into G_EMPLOYEE
47: from per_all_people_f
48: where person_id = p_emp_id
49: and sysdate between effective_start_date and nvl(effective_end_date,sysdate+1);
50: exception
51: when others then