APPS.PAY_RETRO_UTILS_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 194: select pay_retro_assignments_s.nextval

190: l_creation_status varchar2(15);
191: Begin
192: --
193: hr_utility.set_location(l_proc,10);
194: select pay_retro_assignments_s.nextval
195: into p_retro_assignment_id
196: from sys.dual;
197: --
198: l_creation_status := get_creation_status(p_payroll_id);

Line 200: INSERT INTO pay_retro_assignments

196: from sys.dual;
197: --
198: l_creation_status := get_creation_status(p_payroll_id);
199:
200: INSERT INTO pay_retro_assignments
201: ( retro_assignment_id
202: , assignment_id
203: , reprocess_date
204: , start_date

Line 238: FROM pay_retro_assignments pra

234: SELECT
235: pra.start_date
236: ,pra.retro_assignment_id ret_asg_id
237: ,pra.created_by
238: FROM pay_retro_assignments pra
239: WHERE pra.assignment_id = cp_asg
240: AND pra.retro_assignment_action_id is null
241: AND pra.superseding_retro_asg_id is null
242: AND pra.retro_assignment_id <> p_ret_asg_id

Line 256: from pay_retro_assignments pra,

252: pre.retro_component_id,
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: --

Line 276: update pay_retro_assignments

272: , p_start_date => hr_api.g_eot
273: , p_retro_assignment_id => l_ret_asg_id);
274: --
275: for rarec in c_retro_asg(p_asg_id, l_ret_asg_id) loop
276: update pay_retro_assignments
277: set superseding_retro_asg_id = l_ret_asg_id
278: where retro_assignment_id = rarec.ret_asg_id;
279: --
280: update pay_retro_assignments

Line 280: update pay_retro_assignments

276: update pay_retro_assignments
277: set superseding_retro_asg_id = l_ret_asg_id
278: where retro_assignment_id = rarec.ret_asg_id;
279: --
280: update pay_retro_assignments
281: set start_date = rarec.start_date
282: where retro_assignment_id = l_ret_asg_id;
283: --
284: for unprocrec in get_unproc(rarec.ret_asg_id) loop

Line 314: update pay_retro_assignments

310:
311: -- currently created_by is referred by the UI to
312: -- distinguish the system created record, hence
313: -- it has to be inherited.
314: update pay_retro_assignments
315: set reprocess_date = l_min_reprocess_date
316: ,created_by = nvl(l_created_by, created_by)
317: where retro_assignment_id = l_ret_asg_id;
318: --

Line 348: FROM pay_retro_assignments pra

344: Cursor c_retro_asg (cp_asg NUMBER) is
345: SELECT
346: pra.start_date
347: ,pra.retro_assignment_id ret_asg_id
348: FROM pay_retro_assignments pra
349: WHERE pra.assignment_id = cp_asg
350: AND pra.retro_assignment_action_id is null
351: AND pra.superseding_retro_asg_id is null
352: AND approval_status in ('P','A','D');

Line 369: update PAY_RETRO_ASSIGNMENTS

365: l_ret_asg_id := exist_retro_asg.ret_asg_id;
366:
367: -- Make sure status is back to unApproved
368: hr_utility.trace('+ RetroAsg exists so update, retro-asg = '||l_ret_asg_id);
369: update PAY_RETRO_ASSIGNMENTS
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