DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_CONTRIBUTING_PAYMENTS

Line 153: update pay_contributing_payments

149: begin
150: --
151: for payrec in get_payment(p_pactid) loop
152: --
153: update pay_contributing_payments
154: set pre_payment_id = null
155: where pre_payment_id = payrec.pre_payment_id;
156: delete from pay_pre_payments
157: where pre_payment_id = payrec.pre_payment_id;

Line 1963: delete from pay_contributing_payments

1959: -- Remove Batch Element Entry rows
1960: pay_mix_rollback_pkg.undo_mix_asg(p_info.assact_id);
1961: elsif(p_info.action_type = 'PRU') then
1962: -- Remove Rolled up payments
1963: delete from pay_contributing_payments
1964: where assignment_action_id = p_info.assact_id;
1965: end if;
1966: --
1967: -- Delete messages for the assignment action.