122: --
123:
124: cursor c_absence_element_link_id is
125: select *
126: from pay_element_links_f
127: where element_link_id in ( select pel.element_link_id
128: from pay_element_links_f pel,
129: pay_input_values_f piv
130: where pel.element_type_id = piv.element_type_id
124: cursor c_absence_element_link_id is
125: select *
126: from pay_element_links_f
127: where element_link_id in ( select pel.element_link_id
128: from pay_element_links_f pel,
129: pay_input_values_f piv
130: where pel.element_type_id = piv.element_type_id
131: and piv.input_value_id = p_pto_input_value_id
132: and p_effective_date between pel.effective_start_date