APPS.PY_ROLLBACK_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 379: pay_retro_assignments pra

375: --
376: cursor min_reprocess_date is
377: select min(pre.reprocess_date)
378: from pay_retro_entries pre,
379: pay_retro_assignments pra
380: where pre.retro_assignment_id = pra.retro_assignment_id
381: and pra.retro_assignment_action_id = p_assact_id;
382: --
383: begin

Line 422: update pay_retro_assignments ra

418: open min_reprocess_date;
419: fetch min_reprocess_date into l_reprocess_date;
420: close min_reprocess_date;
421: --
422: update pay_retro_assignments ra
423: set ra.retro_assignment_action_id = null,
424: ra.reprocess_date = nvl(l_reprocess_date,ra.reprocess_date)
425: where ra.retro_assignment_action_id = p_assact_id;
426:

Line 1860: -- update pay_retro_assignments ra

1856: -- pay_retro_pkg.merge_retro_assignments(p_info.assact_id);
1857: --
1858: -- -- Remove the asg act id, and in case merge has new earlier entries
1859: -- -- also change the reprocess_date
1860: -- update pay_retro_assignments ra
1861: -- set ra.retro_assignment_action_id = null,
1862: -- ra.reprocess_date = nvl( (
1863: -- select min(effective_date)
1864: -- from pay_retro_entries re