DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 876: from per_absence_attendance_types abt,

872:
873: CURSOR get_vac_hours ( v_asg_id NUMBER,
874: v_eff_date DATE) IS
875: select fnd_number.canonical_to_number(pev.screen_entry_value)
876: from per_absence_attendance_types abt,
877: pay_element_entries_f pee,
878: pay_element_entry_values_f pev
879: where pev.input_value_id = abt.input_value_id
880: and abt.absence_category = 'V'

Line 942: from per_absence_attendance_types abt,

938:
939: CURSOR get_sick_hours ( v_asg_id NUMBER,
940: v_eff_date DATE) IS
941: select fnd_number.canonical_to_number(pev.screen_entry_value)
942: from per_absence_attendance_types abt,
943: pay_element_entries_f pee,
944: pay_element_entry_values_f pev
945: where pev.input_value_id = abt.input_value_id
946: and abt.absence_category = 'S'