DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 867: from per_absence_attendance_types abt,

863:
864: CURSOR get_vac_hours ( v_asg_id NUMBER,
865: v_eff_date DATE) IS
866: select fnd_number.canonical_to_number(pev.screen_entry_value)
867: from per_absence_attendance_types abt,
868: pay_element_entries_f pee,
869: pay_element_entry_values_f pev
870: where pev.input_value_id = abt.input_value_id
871: and abt.absence_category = 'V'

Line 933: from per_absence_attendance_types abt,

929:
930: CURSOR get_sick_hours ( v_asg_id NUMBER,
931: v_eff_date DATE) IS
932: select fnd_number.canonical_to_number(pev.screen_entry_value)
933: from per_absence_attendance_types abt,
934: pay_element_entries_f pee,
935: pay_element_entry_values_f pev
936: where pev.input_value_id = abt.input_value_id
937: and abt.absence_category = 'S'