DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_SWI dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 15: l_absence_category per_absence_attendance_types.absence_category%type ;

11:
12: l_proc varchar2(200) := g_package || 'is_gb_leg_and_category_s';
13:
14: populate_sickness_dates boolean := false;
15: l_absence_category per_absence_attendance_types.absence_category%type ;
16: l_legislation_code varchar2(150);
17:
18: cursor get_category_code (p_absence_attendance_type_id number) is
19: select absence_category

Line 20: from per_absence_attendance_types

16: l_legislation_code varchar2(150);
17:
18: cursor get_category_code (p_absence_attendance_type_id number) is
19: select absence_category
20: from per_absence_attendance_types
21: where absence_attendance_type_id = p_absence_attendance_type_id;
22:
23: begin
24: hr_utility.set_location(' Entering:' || l_proc,5);