DBA Data[Home] [Help]

APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on PO_LINES_ALL

Line 573: CURSOR man_ovr_min_adj_cur(p_order_line_id PO_LINES_ALL.po_line_id%TYPE) IS

569: l_return_status_text VARCHAR2(2000);
570:
571: --E_INVALID_PARAMS EXCEPTION;
572:
573: CURSOR man_ovr_min_adj_cur(p_order_line_id PO_LINES_ALL.po_line_id%TYPE) IS
574: SELECT MIN(ADJV.price_adjustment_id) "MIN_PRICE_ADJ_ID"
575: FROM PO_PRICE_ADJUSTMENTS_V ADJV
576: WHERE ADJV.po_header_id = p_order_header_id --ADJV.draft_id = p_draft_id --sometimes draft_id may be passed as null
577: AND ADJV.po_line_id = p_order_line_id