APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 294: from pay_template_core_objects

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

Line 3308: delete from pay_template_core_objects

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. --