DBA Data[Home] [Help]

APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on PER_PEOPLE_EXTRA_INFO

Line 358: from per_people_extra_info pei

354: , p_effective_date IN date) return varchar2 is
355:
356: cursor cur_eit_sick_reasons (l_person_id IN number) is
357: select PEI_INFORMATION1, PEI_INFORMATION2, PEI_INFORMATION3
358: from per_people_extra_info pei
359: where pei.person_id = l_person_id
360: and pei.information_type = 'NL_DS_SICK_INFO';
361:
362: cursor cur_get_tml_info( l_assignment_id number, l_effective_date date) is