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
826: where defined_balance_id = p_defined_balance_id);
827: --
828: delete
829: from pay_assignment_latest_balances
833: from pay_person_latest_balances
834: where defined_balance_id = p_defined_balance_id;
835: --
836: delete
837: from pay_latest_balances
838: where defined_balance_id = p_defined_balance_id;
839: end delete_latest_balances;
840: -- ----------------------------------------------------------------------------
841: -- |-----------------------< update_balance_dimension >-----------------------|