1231:
1232: CURSOR get_vac_hours ( v_asg_id NUMBER,
1233: v_eff_date DATE) IS
1234: select fnd_number.canonical_to_number(pev.screen_entry_value)
1235: from per_absence_attendance_types abt,
1236: pay_element_entries_f pee,
1237: pay_element_entry_values_f pev
1238: where pev.input_value_id = abt.input_value_id
1239: and abt.absence_category = 'V'
1297:
1298: CURSOR get_sick_hours ( v_asg_id NUMBER,
1299: v_eff_date DATE) IS
1300: select fnd_number.canonical_to_number(pev.screen_entry_value)
1301: from per_absence_attendance_types abt,
1302: pay_element_entries_f pee,
1303: pay_element_entry_values_f pev
1304: where pev.input_value_id = abt.input_value_id
1305: and abt.absence_category = 'S'