APPS.PO_PRICE_HELPER dependencies on STANDARD

Line 60: c_STANDARD CONSTANT VARCHAR2(10) := 'STANDARD';

56:
57: c_UNIT_PRICE CONSTANT VARCHAR2(30) := 'UNIT_PRICE';
58:
59: -- PO_HEADERS_ALL.type_lookup_code
60: c_STANDARD CONSTANT VARCHAR2(10) := 'STANDARD';
61:
62: -- PO_LINES_ALL.order_type_lookup_code
63: c_RATE CONSTANT VARCHAR2(5) := 'RATE';
64:

Line 413: AND HEADER.type_lookup_code = c_STANDARD

409: , PO_HEADERS_ALL HEADER
410: WHERE
411: LINE.po_line_id = p_line_id_tbl(i)
412: AND HEADER.po_header_id = LINE.po_header_id
413: AND HEADER.type_lookup_code = c_STANDARD
414: AND LINE.order_type_lookup_code <> c_RATE
415: AND EXISTS
416: (SELECT NULL
417: FROM PO_DISTRIBUTIONS_ALL DIST

Line 546: AND HEADER.type_lookup_code = c_STANDARD

542: WHERE
543: SES.key = l_data_key
544: AND LINE.po_line_id = SES.num1
545: AND HEADER.po_header_id = LINE.po_header_id
546: AND HEADER.type_lookup_code = c_STANDARD
547: AND PARAMS.org_id = HEADER.org_id
548: ;
549:
550: d_position := 100;

Line 854: AND HEADER.type_lookup_code = c_STANDARD

850: WHERE
851: SES.key = l_data_key
852: AND LINE.po_line_id = SES.num1
853: AND HEADER.po_header_id = LINE.po_header_id
854: AND HEADER.type_lookup_code = c_STANDARD
855: AND HEADER.authorization_status <> c_INCOMPLETE
856: AND (SES.char1 IS NULL OR SES.char1 = c_NON_CUMULATIVE)
857: ;
858:

Line 993: --

989: , p_uom IN VARCHAR2
990: , p_in_price IN NUMBER
991: , p_currency_code IN VARCHAR2
992: , p_price_break_lookup_code IN VARCHAR2
993: --
994: , p_src_flag IN VARCHAR2 DEFAULT NULL
995: , p_doc_sub_type IN VARCHAR2 DEFAULT NULL
996: --
997: , x_return_status OUT NOCOPY VARCHAR2