9810: DELETE psb_ws_distributions
9811: WHERE distribution_id = l_br_distribution_rec.distribution_id;
9812: END LOOP;
9813:
9814: -- Delete from psb_workflow_processes.
9815: DELETE psb_workflow_processes
9816: WHERE worksheet_id = p_budget_revision_id
9817: AND document_type = 'BR' ;
9818:
9811: WHERE distribution_id = l_br_distribution_rec.distribution_id;
9812: END LOOP;
9813:
9814: -- Delete from psb_workflow_processes.
9815: DELETE psb_workflow_processes
9816: WHERE worksheet_id = p_budget_revision_id
9817: AND document_type = 'BR' ;
9818:
9819: --Find system data extract for the given budget revision