DBA Data[Home] [Help]

APPS.JL_JLCOFARR_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        COMPANY_NAME,
        CATEGORY_FLEX_STRUCTURE
      INTO COMPANY_NAME,CAT_FLEX
      FROM
        FA_SYSTEM_CONTROLS;
Line: 22

      SELECT
        DISTINCT
        C.CURRENCY_CODE
      INTO CURRENCY_CODE
      FROM
        GL_SETS_OF_BOOKS C,
        FA_BOOK_CONTROLS B,
        FA_BOOKS A
      WHERE A.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
        AND A.BOOK_TYPE_CODE = B.BOOK_TYPE_CODE
        AND B.SET_OF_BOOKS_ID = C.SET_OF_BOOKS_ID;
Line: 141

	    MODE="SELECT"
	    DISPLAY="ALL"');*/