APPS.HXC_TIMEKEEPER_WF_PKG dependencies on PER_PEOPLE_F

Line 374: select p.full_name from per_people_f p

370: p_effective_date in DATE)
371: return varchar2
372: is
373: cursor csr_name(b_person_id NUMBER, b_effective_date DATE) is
374: select p.full_name from per_people_f p
375: where p.person_id=b_person_id
376: and b_effective_date between p.effective_start_date and p.effective_end_date;
377:
378: cursor csr_closest_name1