APPS.JL_JLCOGLAM_XMLP_PKG SQL Statements

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

Line: 7

        SELECT
          NVL(MIN(LITERAL_CODE)
             ,0)
        INTO CP_LITERAL_START
        FROM
          JL_CO_GL_MG_LITERALS
        WHERE REPORTED_YEAR = P_REPORTED_YEAR
          AND SET_OF_BOOKS_ID = P_SOB_ID;

Line: 25

        SELECT
          NVL(MAX(LITERAL_CODE)
             ,9999)
        INTO CP_LITERAL_END
        FROM
          JL_CO_GL_MG_LITERALS
        WHERE REPORTED_YEAR = P_REPORTED_YEAR
          AND SET_OF_BOOKS_ID = P_SOB_ID;

Line: 41

    SELECT
      CHART_OF_ACCOUNTS_ID,
      CURRENCY_CODE
    INTO C_CHART_OF_ACCOUNTS_ID,P_CURRENCY_CODE
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 57

      SELECT
        NAME COMP_NAME,
        REGISTRATION_NUMBER COMP_ID
      INTO P_REPORT_SUB_TITLE,CP_COMP_NIT
      FROM
        XLE_FIRSTPARTY_INFORMATION_V
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 66

        SELECT
          NAME
        INTO P_REPORT_SUB_TITLE
        FROM
          GL_SETS_OF_BOOKS
        WHERE SET_OF_BOOKS_ID = P_SOB_ID
          AND ROWNUM < 2;