APPS.JL_JLCOGLNE_XMLP_PKG SQL Statements

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

Line: 14

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

Line: 21

      SELECT
        PERIOD_NAME
      INTO CP_PERIOD_NAME
      FROM
        JL_CO_GL_CONC_CTRL
      WHERE PROCESS_ID = P_CONC_ID;

Line: 56

    SELECT
      count(*)
    INTO NIT_0_COUNT
    FROM
      JL_CO_GL_TRX
    WHERE PROCESS_ID = P_CONC_ID
      AND NIT_ID = (
      SELECT
        NIT_ID
      FROM
        JL_CO_GL_NITS
      WHERE NIT = '0' );