DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_RUN_BALANCES

Line 1760: delete from pay_run_balances

1756: ,p_info.grp_multi_thread);
1757: --
1758: -- now delete assignment level run balances
1759: --
1760: delete from pay_run_balances
1761: where assignment_action_id = p_info.assact_id;
1762: else
1763: --
1764: -- now update assignment level run balances

Line 1766: update pay_run_balances

1762: else
1763: --
1764: -- now update assignment level run balances
1765: --
1766: update pay_run_balances
1767: set balance_value = 0
1768: where assignment_action_id = p_info.assact_id;
1769: end if;
1770: --

Line 3272: delete from pay_run_balances

3268: -- delete group level run balances
3269: --
3270: if (info.sequenced_flag and
3271: rollback_complete(info.pact_id)) then
3272: delete from pay_run_balances
3273: where payroll_action_id = info.pact_id;
3274: end if;
3275: --
3276: if(info.dml_mode = 'NONE') then

Line 3507: delete from pay_run_balances

3503: -- Remove the group run balances for resersal.
3504: --
3505: if (info.action_type = 'V') then
3506: --
3507: delete from pay_run_balances
3508: where payroll_action_id = info.pact_id;
3509: --
3510: end if;
3511: end if;