APPS.AHL_OSP_ORDERS_PVT dependencies on PO_LINE_TYPES

Line 2682: SELECT 'x' FROM po_line_types

2678: PROCEDURE validate_po_line_type(
2679: p_po_line_type_id IN NUMBER
2680: )IS
2681: CURSOR val_po_line_type_id_csr(p_po_line_type_id IN NUMBER) IS
2682: SELECT 'x' FROM po_line_types
2683: WHERE line_type_id = p_po_line_type_id and
2684: ORDER_TYPE_LOOKUP_CODE = 'QUANTITY' and
2685: NVL(OUTSIDE_OPERATION_FLAG, G_NO_FLAG) = G_NO_FLAG;
2686: l_exist VARCHAR2(1);

Line 7369: FROM po_line_types

7365: l_service_item_id NUMBER;
7366: l_organization_id NUMBER;
7367: CURSOR po_line_type_id_csr(p_po_line_type IN VARCHAR2) IS
7368: SELECT line_type_id
7369: FROM po_line_types
7370: WHERE line_type = p_po_line_type
7371: AND order_type_lookup_code = 'QUANTITY'
7372: AND NVL(outside_operation_flag, G_NO_FLAG) = G_NO_FLAG;
7373: l_po_line_type_id NUMBER;