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
835: where defined_balance_id = p_defined_balance_id);
836: --
837: delete
838: from pay_assignment_latest_balances
842: from pay_person_latest_balances
843: where defined_balance_id = p_defined_balance_id;
844: --
845: delete
846: from pay_latest_balances
847: where defined_balance_id = p_defined_balance_id;
848: end delete_latest_balances;
849: -- ----------------------------------------------------------------------------
850: -- |-----------------------< update_balance_dimension >-----------------------|