APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_WS_DISTRIBUTIONS

Line 9676: FROM psb_ws_distributions

9672:
9673: CURSOR l_br_distribution_csr
9674: IS
9675: SELECT distribution_id
9676: FROM psb_ws_distributions
9677: WHERE worksheet_id = p_budget_revision_id
9678: AND distribution_option_flag = 'R';
9679:
9680: CURSOR l_br_position_csr

Line 9809: -- Delete from psb_ws_distributions.

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
9811: WHERE distribution_id = l_br_distribution_rec.distribution_id;
9812: END LOOP;
9813:

Line 9810: DELETE psb_ws_distributions

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
9811: WHERE distribution_id = l_br_distribution_rec.distribution_id;
9812: END LOOP;
9813:
9814: -- Delete from psb_workflow_processes.