[Home] [Help]
576:
577: CURSOR get_vac_hours ( v_asg_id NUMBER,
578: v_eff_date DATE) IS
579: select pev.screen_entry_value
580: from per_absence_attendance_types abt,
581: pay_element_entries_f pee,
582: pay_element_entry_values_f pev
583: where pev.input_value_id = abt.input_value_id
584: and abt.absence_category = 'V'
632:
633: CURSOR get_sick_hours ( v_asg_id NUMBER,
634: v_eff_date DATE) IS
635: select pev.screen_entry_value
636: from per_absence_attendance_types abt,
637: pay_element_entries_f pee,
638: pay_element_entry_values_f pev
639: where pev.input_value_id = abt.input_value_id
640: and abt.absence_category = 'S'