[Home] [Help]
144: begin
145: --
146: for payrec in get_payment(p_pactid) loop
147: --
148: update pay_contributing_payments
149: set pre_payment_id = null
150: where pre_payment_id = payrec.pre_payment_id;
151: delete from pay_pre_payments
152: where pre_payment_id = payrec.pre_payment_id;
1880: -- Remove Batch Element Entry rows
1881: pay_mix_rollback_pkg.undo_mix_asg(p_info.assact_id);
1882: elsif(p_info.action_type = 'PRU') then
1883: -- Remove Rolled up payments
1884: delete from pay_contributing_payments
1885: where assignment_action_id = p_info.assact_id;
1886: end if;
1887: --
1888: -- Delete messages for the assignment action.