DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_RETRO_ENTRIES

Line 378: from pay_retro_entries pre,

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

Line 1864: -- from pay_retro_entries re

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
1865: -- where re.retro_assignment_id = ra.retro_assignment_id )
1866: -- ,ra.reprocess_date)
1867: -- where ra.retro_assignment_action_id = p_info.assact_id;
1868: --