APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_DISTRIBUTIONS_ALL

Line 2600: SELECT po_distribution_id FROM po_distributions_all

2596:
2597: l_return_status VARCHAR2(2);
2598:
2599: CURSOR c_get_dist(p_po_line_id NUMBER) IS
2600: SELECT po_distribution_id FROM po_distributions_all
2601: WHERE po_line_id = p_po_line_id;
2602:
2603: BEGIN
2604:

Line 2733: SELECT quantity_cancelled, amount_cancelled INTO l_dist_qty_cancel, l_dist_amt_cancel FROM po_distributions_all

2729: /*ELSIF (p_po_mode = po_document_action_pvt.g_doc_action_CANCEL) THEN
2730:
2731: d_progress := 60;
2732: FOR c_get_dist_rec IN c_get_dist(p_po_line_id) LOOP
2733: SELECT quantity_cancelled, amount_cancelled INTO l_dist_qty_cancel, l_dist_amt_cancel FROM po_distributions_all
2734: WHERE po_distribution_id = c_get_dist_rec.po_distribution_id;
2735:
2736: l_tot_dist_can_amt := l_tot_dist_can_amt + l_dist_amt_cancel;
2737: l_tot_dist_can_qty := l_tot_dist_can_qty + l_dist_qty_cancel;