822: delete
823: from pay_balance_context_values
824: where latest_balance_id in (
825: select latest_balance_id
826: from pay_assignment_latest_balances
827: where defined_balance_id = p_defined_balance_id
828: union all
829: select latest_balance_id
830: from pay_assignment_latest_balances
826: from pay_assignment_latest_balances
827: where defined_balance_id = p_defined_balance_id
828: union all
829: select latest_balance_id
830: from pay_assignment_latest_balances
831: where defined_balance_id = p_defined_balance_id
832: union all
833: select latest_balance_id
834: from pay_latest_balances
834: from pay_latest_balances
835: where defined_balance_id = p_defined_balance_id);
836: --
837: delete
838: from pay_assignment_latest_balances
839: where defined_balance_id = p_defined_balance_id;
840: --
841: delete
842: from pay_person_latest_balances