APPS.HR_LOA_SS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 4504: l_absence_category per_absence_attendance_types.absence_category%type ;

4500:
4501: l_proc varchar2(200) := g_package || 'is_gb_leg_and_category_s';
4502:
4503: populate_sickness_dates boolean := false;
4504: l_absence_category per_absence_attendance_types.absence_category%type ;
4505: l_legislation_code varchar2(150);
4506:
4507: cursor get_category_code (p_absence_attendance_type_id number) is
4508: select absence_category

Line 4509: from per_absence_attendance_types

4505: l_legislation_code varchar2(150);
4506:
4507: cursor get_category_code (p_absence_attendance_type_id number) is
4508: select absence_category
4509: from per_absence_attendance_types
4510: where absence_attendance_type_id = p_absence_attendance_type_id;
4511:
4512: begin
4513: hr_utility.set_location(' Entering:' || l_proc,5);

Line 9175: from per_absence_attendance_types abt

9171: ,piv.input_value_id
9172: ,piv.max_value -- WWBUG #2602856
9173: ,piv.min_value -- WWBUG #2602856
9174: ,pet.element_link_id -- WWBUG #2602856
9175: from per_absence_attendance_types abt
9176: ,pay_input_values_f piv
9177: ,pay_element_links_f pet
9178: where abt.absence_attendance_type_id = p_absence_attendance_type_id
9179: and abt.input_value_id = piv.input_value_id(+)