76: l_input_value_name VARCHAR2,
77: l_element_type_id NUMBER
78: ) IS
79: SELECT input_value_id
80: FROM pay_input_values_f
81: WHERE element_type_id = l_element_type_id
82: AND UPPER (NAME) = UPPER (l_input_value_name)
83: AND business_group_id IS NULL
84: AND legislation_code = 'US';
123: IF (get_flex_value_set_id%FOUND)
124: AND (l_flex_value_set_id IS NOT NULL) THEN
125:
126: -- Stamp value set in input value of FLSA Time Definition element
127: UPDATE pay_input_values_f
128: SET value_set_id = l_flex_value_set_id
129: WHERE input_value_id = l_input_value_id
130: AND business_group_id IS NULL
131: AND legislation_code = 'US';