APPS.PAY_RETRO_UTILS_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 161: select pay_retro_assignments_s.nextval

157: l_creation_status varchar2(15);
158: Begin
159: --
160: hr_utility.set_location(l_proc,10);
161: select pay_retro_assignments_s.nextval
162: into p_retro_assignment_id
163: from sys.dual;
164: --
165: l_creation_status := get_creation_status(p_payroll_id);

Line 167: INSERT INTO pay_retro_assignments

163: from sys.dual;
164: --
165: l_creation_status := get_creation_status(p_payroll_id);
166:
167: INSERT INTO pay_retro_assignments
168: ( retro_assignment_id
169: , assignment_id
170: , reprocess_date
171: , start_date

Line 205: FROM pay_retro_assignments pra

201: SELECT
202: pra.start_date
203: ,pra.retro_assignment_id ret_asg_id
204: ,pra.created_by
205: FROM pay_retro_assignments pra
206: WHERE pra.assignment_id = cp_asg
207: AND pra.retro_assignment_action_id is null
208: AND pra.superseding_retro_asg_id is null
209: AND pra.retro_assignment_id <> p_ret_asg_id

Line 223: from pay_retro_assignments pra,

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

Line 243: update pay_retro_assignments

239: , p_start_date => hr_api.g_eot
240: , p_retro_assignment_id => l_ret_asg_id);
241: --
242: for rarec in c_retro_asg(p_asg_id, l_ret_asg_id) loop
243: update pay_retro_assignments
244: set superseding_retro_asg_id = l_ret_asg_id
245: where retro_assignment_id = rarec.ret_asg_id;
246: --
247: update pay_retro_assignments

Line 247: update pay_retro_assignments

243: update pay_retro_assignments
244: set superseding_retro_asg_id = l_ret_asg_id
245: where retro_assignment_id = rarec.ret_asg_id;
246: --
247: update pay_retro_assignments
248: set start_date = rarec.start_date
249: where retro_assignment_id = l_ret_asg_id;
250: --
251: for unprocrec in get_unproc(rarec.ret_asg_id) loop

Line 281: update pay_retro_assignments

277:
278: -- currently created_by is referred by the UI to
279: -- distinguish the system created record, hence
280: -- it has to be inherited.
281: update pay_retro_assignments
282: set reprocess_date = l_min_reprocess_date
283: ,created_by = nvl(l_created_by, created_by)
284: where retro_assignment_id = l_ret_asg_id;
285: --

Line 315: FROM pay_retro_assignments pra

311: Cursor c_retro_asg (cp_asg NUMBER) is
312: SELECT
313: pra.start_date
314: ,pra.retro_assignment_id ret_asg_id
315: FROM pay_retro_assignments pra
316: WHERE pra.assignment_id = cp_asg
317: AND pra.retro_assignment_action_id is null
318: AND pra.superseding_retro_asg_id is null
319: AND approval_status in ('P','A','D');

Line 336: update PAY_RETRO_ASSIGNMENTS

332: l_ret_asg_id := exist_retro_asg.ret_asg_id;
333:
334: -- Make sure status is back to unApproved
335: hr_utility.trace('+ RetroAsg exists so update, retro-asg = '||l_ret_asg_id);
336: update PAY_RETRO_ASSIGNMENTS
337: set APPROVAL_STATUS = 'P'
338: where ASSIGNMENT_ID = p_asg_id
339: /*Bug#8306525*/
340: and RETRO_ASSIGNMENT_ACTION_ID IS NULL;