410: ,c_iv_name varchar2) IS
411: SELECT input_value_id
412: ,piv.name
413: ,piv.element_type_id
414: FROM pay_input_values_f piv
415: ,pay_element_types_f pet
416: WHERE element_name = c_ele_name
417: AND piv.element_type_id = pet.element_type_id
418: AND (piv.business_group_id = p_bg_id OR piv.business_group_id IS NULL)
421:
422: CURSOR csr_updinput(c_ip_id number
423: ,c_element_type_id number) IS
424: SELECT rowid
425: FROM pay_input_values_f
426: WHERE input_value_id = c_ip_id
427: AND element_type_id = c_element_type_id
428: FOR UPDATE NOWAIT;
429:
460: --
461: hr_utility.set_location (l_proc_name, 30);
462: --
463:
464: UPDATE pay_input_values_f
465: SET default_value = p_def_value
466: WHERE rowid = csr_updinput_rec.rowid;
467:
468: END LOOP;