APPS.AHL_OSP_ORDERS_PVT dependencies on PO_LINE_TYPES

Line 2661: SELECT 'x' FROM po_line_types

2657: PROCEDURE validate_po_line_type(
2658: p_po_line_type_id IN NUMBER
2659: )IS
2660: CURSOR val_po_line_type_id_csr(p_po_line_type_id IN NUMBER) IS
2661: SELECT 'x' FROM po_line_types
2662: WHERE line_type_id = p_po_line_type_id and
2663: ORDER_TYPE_LOOKUP_CODE = 'QUANTITY' and
2664: NVL(OUTSIDE_OPERATION_FLAG, G_NO_FLAG) = G_NO_FLAG;
2665: l_exist VARCHAR2(1);

Line 6920: FROM po_line_types

6916: l_service_item_id NUMBER;
6917: l_organization_id NUMBER;
6918: CURSOR po_line_type_id_csr(p_po_line_type IN VARCHAR2) IS
6919: SELECT line_type_id
6920: FROM po_line_types
6921: WHERE line_type = p_po_line_type
6922: AND order_type_lookup_code = 'QUANTITY'
6923: AND NVL(outside_operation_flag, G_NO_FLAG) = G_NO_FLAG;
6924: l_po_line_type_id NUMBER;