The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT A.*,B.CHAPTER,B.SECTION,B.SUBJECT,B.PAGE,B.FIGURE,B.NOTE
FROM AHL_DOC_TITLE_ASSOS_B a, AHL_DOC_TITLE_ASSOS_TL B
WHERE A.DOC_TITLE_ASSO_ID=B.DOC_TITLE_ASSO_ID
AND A.DOC_TITLE_ASSO_ID=C_DOC_TITLE_ASSO_ID
AND B.LANGUAGE=USERENV('LANG');
SELECT lookup_code INTO x_lookup_code
FROM FND_LOOKUP_VALUES_VL
WHERE lookup_type = p_lookup_type
AND lookup_code = p_lookup_code
AND sysdate between start_date_active
AND nvl(end_date_active,sysdate);
SELECT lookup_code INTO x_lookup_code
FROM FND_LOOKUP_VALUES_VL
WHERE lookup_type = p_lookup_type
AND meaning = p_meaning
AND sysdate between start_date_active
AND nvl(end_date_active,sysdate);
SELECT document_id
FROM ahl_documents_b
WHERE document_no = c_document_no;
SELECT doc_revision_id
FROM ahl_doc_revisions_b
WHERE document_id = c_document_id;
SELECT count(*)
FROM ahl_doc_revisions_b
WHERE document_id = c_document_id;
SELECT doc_revision_id
FROM ahl_doc_revisions_b
WHERE document_id = c_document_id
and revision_no= c_doc_rev_no;
FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
AHL_DEBUG_PUB.debug( 'Select document from lov');
FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
AHL_DEBUG_PUB.debug( 'Select document from lov');