9182: ,piv.max_value -- WWBUG #2602856
9183: ,piv.min_value -- WWBUG #2602856
9184: ,pet.element_link_id -- WWBUG #2602856
9185: from per_absence_attendance_types abt
9186: ,pay_input_values_f piv
9187: ,pay_element_links_f pet
9188: where abt.absence_attendance_type_id = p_absence_attendance_type_id
9189: and abt.input_value_id = piv.input_value_id(+)
9190: and piv.element_type_id = pet.element_type_id(+)
9391: ,piv.max_value -- WWBUG #2602856
9392: ,piv.min_value -- WWBUG #2602856
9393: ,pet.element_link_id -- WWBUG #2602856
9394: from per_absence_attendance_types abt
9395: ,pay_input_values_f piv
9396: ,pay_element_links_f pet
9397: where abt.absence_attendance_type_id = p_absence_attendance_type_id
9398: and abt.input_value_id = piv.input_value_id(+)
9399: and piv.element_type_id = pet.element_type_id(+)