9798:
9799: END IF ; -- if p_revise_by_position is 'Y'.
9800: --
9801: --
9802: -- Delete from psb_ws_distribution_details.
9803:
9804: FOR l_br_distribution_rec IN l_br_distribution_csr
9805: LOOP
9806: DELETE psb_ws_distribution_details
9802: -- Delete from psb_ws_distribution_details.
9803:
9804: FOR l_br_distribution_rec IN l_br_distribution_csr
9805: LOOP
9806: DELETE psb_ws_distribution_details
9807: WHERE distribution_id = l_br_distribution_rec.distribution_id;
9808:
9809: -- Delete from psb_ws_distributions.
9810: DELETE psb_ws_distributions