[Home] [Help]
813: delete
814: from pay_balance_context_values
815: where latest_balance_id in (
816: select latest_balance_id
817: from pay_assignment_latest_balances
818: where defined_balance_id = p_defined_balance_id
819: union all
820: select latest_balance_id
821: from pay_assignment_latest_balances
817: from pay_assignment_latest_balances
818: where defined_balance_id = p_defined_balance_id
819: union all
820: select latest_balance_id
821: from pay_assignment_latest_balances
822: where defined_balance_id = p_defined_balance_id
823: union all
824: select latest_balance_id
825: from pay_latest_balances
825: from pay_latest_balances
826: where defined_balance_id = p_defined_balance_id);
827: --
828: delete
829: from pay_assignment_latest_balances
830: where defined_balance_id = p_defined_balance_id;
831: --
832: delete
833: from pay_person_latest_balances