APPS.PY_ROLLBACK_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 384: pay_retro_assignments pra

380: --
381: cursor min_reprocess_date is
382: select min(pre.reprocess_date)
383: from pay_retro_entries pre,
384: pay_retro_assignments pra
385: where pre.retro_assignment_id = pra.retro_assignment_id
386: and pra.retro_assignment_action_id = p_assact_id;
387: --
388: begin

Line 427: update pay_retro_assignments ra

423: open min_reprocess_date;
424: fetch min_reprocess_date into l_reprocess_date;
425: close min_reprocess_date;
426: --
427: update pay_retro_assignments ra
428: set ra.retro_assignment_action_id = null,
429: ra.reprocess_date = nvl(l_reprocess_date,ra.reprocess_date)
430: where ra.retro_assignment_action_id = p_assact_id;
431:

Line 1939: -- update pay_retro_assignments ra

1935: -- pay_retro_pkg.merge_retro_assignments(p_info.assact_id);
1936: --
1937: -- -- Remove the asg act id, and in case merge has new earlier entries
1938: -- -- also change the reprocess_date
1939: -- update pay_retro_assignments ra
1940: -- set ra.retro_assignment_action_id = null,
1941: -- ra.reprocess_date = nvl( (
1942: -- select min(effective_date)
1943: -- from pay_retro_entries re