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 9185: from per_absence_attendance_types abt

9181: ,piv.input_value_id
9182: ,piv.max_value -- WWBUG #2602856
9183: ,piv.min_value -- WWBUG #2602856
9184: ,pet.element_link_id -- WWBUG #2602856
9185: from per_absence_attendance_types abt
9186: ,pay_input_values_f piv
9187: ,pay_element_links_f pet
9188: where abt.absence_attendance_type_id = p_absence_attendance_type_id
9189: and abt.input_value_id = piv.input_value_id(+)

Line 9394: from per_absence_attendance_types abt

9390: ,piv.input_value_id
9391: ,piv.max_value -- WWBUG #2602856
9392: ,piv.min_value -- WWBUG #2602856
9393: ,pet.element_link_id -- WWBUG #2602856
9394: from per_absence_attendance_types abt
9395: ,pay_input_values_f piv
9396: ,pay_element_links_f pet
9397: where abt.absence_attendance_type_id = p_absence_attendance_type_id
9398: and abt.input_value_id = piv.input_value_id(+)