[Home] [Help]
64: If p_person_id is not null
65: then
66: select substr(full_name,1,50)
67: into hold_employee_name
68: from per_people_f
69: where person_id = p_person_id
70: and sysdate between effective_start_date
71: and nvl(effective_end_date,sysdate + 1)
72: and (employee_number IS NOT NULL OR npw_number IS NOT NULL );