[Home] [Help]
3098:
3099: delete from pay_element_type_rules
3100: where element_set_id = l_new_surrogate_key;
3101:
3102: delete from pay_ele_classification_rules
3103: where element_set_id = l_new_surrogate_key;
3104:
3105: update pay_element_sets
3106: set element_set_type = stu_rec.element_set_type
3221: from pay_element_classifications
3222: where classification_id = ele_class.classification_id;
3223:
3224: BEGIN
3225: insert into pay_ele_classification_rules
3226: (element_set_id
3227: ,classification_id
3228: ,last_update_date
3229: ,last_updated_by
3239: ,ele_class.created_by
3240: ,ele_class.creation_date);
3241: EXCEPTION WHEN OTHERS THEN
3242: hr_legislation.hrrunprc_trace_on;
3243: hr_utility.trace('ins pay_ele_classification_rules');
3244: hr_utility.trace('element_set_id ' ||
3245: to_char(ele_class.element_set_id));
3246: hr_utility.trace('classification_id ' ||
3247: to_char(ele_class.classification_id));