DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_RETRO_ENTRIES

Line 383: from pay_retro_entries pre,

379: l_reprocess_date date;
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: --

Line 1943: -- from pay_retro_entries re

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
1944: -- where re.retro_assignment_id = ra.retro_assignment_id )
1945: -- ,ra.reprocess_date)
1946: -- where ra.retro_assignment_action_id = p_info.assact_id;
1947: --