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 257: pay_retro_entries pre

253: pre.owner_type,
254: pre.system_reprocess_date,
255: pre.created_by
256: from pay_retro_assignments pra,
257: pay_retro_entries pre
258: where pra.retro_assignment_id = p_ret_asg_id
259: and pra.retro_assignment_id = pre.retro_assignment_id;
260: --
261: l_ret_asg_id number;

Line 298: update pay_retro_entries

294: unprocrec.owner_type,
295: unprocrec.system_reprocess_date
296: );
297: -- inherit created_by.
298: update pay_retro_entries
299: set created_by = unprocrec.created_by
300: where retro_assignment_id = l_ret_asg_id
301: and element_entry_id = unprocrec.element_entry_id;
302: --

Line 374: delete from PAY_RETRO_ENTRIES

370: set APPROVAL_STATUS = 'P'
371: where ASSIGNMENT_ID = p_asg_id;
372:
373: -- Delete any system retro-element records as were about to repopulate
374: delete from PAY_RETRO_ENTRIES
375: where RETRO_ASSIGNMENT_ID = exist_retro_asg.ret_asg_id
376: and owner_type = 'S';
377:
378: end loop;