APPS.PAY_RETRO_UTILS_PKG dependencies on PAY_RETRO_ENTRIES

Line 105: INSERT INTO pay_retro_entries

101: p_eff_date);
102:
103: hr_utility.set_location(l_proc,20);
104: --
105: INSERT INTO pay_retro_entries
106: ( retro_assignment_id
107: , element_entry_id
108: , reprocess_date
109: , effective_date

Line 224: pay_retro_entries pre

220: pre.owner_type,
221: pre.system_reprocess_date,
222: pre.created_by
223: from pay_retro_assignments pra,
224: pay_retro_entries pre
225: where pra.retro_assignment_id = p_ret_asg_id
226: and pra.retro_assignment_id = pre.retro_assignment_id;
227: --
228: l_ret_asg_id number;

Line 265: update pay_retro_entries

261: unprocrec.owner_type,
262: unprocrec.system_reprocess_date
263: );
264: -- inherit created_by.
265: update pay_retro_entries
266: set created_by = unprocrec.created_by
267: where retro_assignment_id = l_ret_asg_id
268: and element_entry_id = unprocrec.element_entry_id;
269: --

Line 344: delete from PAY_RETRO_ENTRIES

340: and RETRO_ASSIGNMENT_ACTION_ID IS NULL;
341:
342:
343: -- Delete any system retro-element records as were about to repopulate
344: delete from PAY_RETRO_ENTRIES
345: where RETRO_ASSIGNMENT_ID = exist_retro_asg.ret_asg_id
346: and owner_type = 'S';
347:
348: end loop;