APPS.AHL_DI_ASSO_DOC_GEN_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

        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');

Line: 421

          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);

Line: 431

          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);

Line: 462

	SELECT document_id
	FROM ahl_documents_b
	WHERE document_no = c_document_no;

Line: 468

	SELECT doc_revision_id
	FROM ahl_doc_revisions_b
	WHERE document_id = c_document_id;

Line: 474

	SELECT count(*)
	FROM ahl_doc_revisions_b
	WHERE document_id = c_document_id;

Line: 480

	SELECT doc_revision_id
	FROM ahl_doc_revisions_b
	WHERE document_id = c_document_id
	  and revision_no= c_doc_rev_no;

Line: 569

					FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

Line: 572

						AHL_DEBUG_PUB.debug( 'Select document from lov');

Line: 584

					FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

Line: 587

						AHL_DEBUG_PUB.debug( 'Select document from lov');