DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_RUN_BALANCES

Line 1737: delete from pay_run_balances

1733: ,p_info.grp_multi_thread);
1734: --
1735: -- now delete assignment level run balances
1736: --
1737: delete from pay_run_balances
1738: where assignment_action_id = p_info.assact_id;
1739: else
1740: --
1741: -- now update assignment level run balances

Line 1743: update pay_run_balances

1739: else
1740: --
1741: -- now update assignment level run balances
1742: --
1743: update pay_run_balances
1744: set balance_value = 0
1745: where assignment_action_id = p_info.assact_id;
1746: end if;
1747: --

Line 3151: delete from pay_run_balances

3147: -- delete group level run balances
3148: --
3149: if (info.sequenced_flag and
3150: rollback_complete(info.pact_id)) then
3151: delete from pay_run_balances
3152: where payroll_action_id = info.pact_id;
3153: end if;
3154: --
3155: if(info.dml_mode = 'NONE') then

Line 3386: delete from pay_run_balances

3382: -- Remove the group run balances for resersal.
3383: --
3384: if (info.action_type = 'V') then
3385: --
3386: delete from pay_run_balances
3387: where payroll_action_id = info.pact_id;
3388: --
3389: end if;
3390: end if;