290: core_object_id,
291: shadow_object_id,
292: effective_date,
293: object_version_number
294: from pay_template_core_objects
295: where template_id = p_template_id
296: order by core_object_type
297: for update of core_object_id;
298: begin
3304: hr_utility.set_location('Entering:'|| l_proc, 10);
3305: ---------------------------------------------
3306: -- Delete template core object rows first. --
3307: ---------------------------------------------
3308: delete from pay_template_core_objects
3309: where template_id = p_template_id
3310: ;
3311: ----------------------------------
3312: -- Delete in foreign key order. --