APPS.JG_JGZZGLJRN_XMLP_PKG SQL Statements

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

Line: 13

    SELECT
      TO_CHAR(SYSDATE
             ,'YYYY-MM-DD') || 'T' || TO_CHAR(SYSDATE
             ,'HH24:MI:SS'),
      FND_DATE.CANONICAL_TO_DATE(P_START_DATE),
      FND_DATE.CANONICAL_TO_DATE(P_END_DATE)
    INTO REP_EXECUTION_DATE,L_START_DATE,L_END_DATE
    FROM
      DUAL;

Line: 23

      SELECT
        NAME
      INTO DATA_ACCESS_SET_NAME
      FROM
        GL_ACCESS_SETS
      WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;

Line: 48

        SELECT
          OBJECT_TYPE_CODE
        INTO L_LEDGER_TYPE
        FROM
          GL_LEDGERS
        WHERE LEDGER_ID = P_LEDGER_ID;

Line: 204

      P_POSTING_STATUS := ' AND ' || ' GLBATCH.STATUS IN ' || '(SELECT LOOKUP_CODE FROM GL_LOOKUPS ' || 'WHERE LOOKUP_TYPE = ''MJE_BATCH_STATUS'' ' || 'AND LOOKUP_CODE NOT IN (''S'', ''I'', ''U'', ''P'')) ';

Line: 282

    SELECT
      MEANING
    INTO POSTING_STATUS_PARAM
    FROM
      GL_LOOKUPS
    WHERE LOOKUP_CODE = P_STATUS
      AND LOOKUP_TYPE = 'JOURNAL_REPORT_TYPE';

Line: 290

      SELECT
        DESCRIPTION
      INTO BALANCE_TYPE_PARAM
      FROM
        GL_LOOKUPS
      WHERE LOOKUP_TYPE = 'BATCH_TYPE'
        AND LOOKUP_CODE = P_BALANCE_TYPE;

Line: 299

      SELECT
        USER_JE_SOURCE_NAME
      INTO JRNL_SOURCE_PARAM
      FROM
        GL_JE_SOURCES
      WHERE JE_SOURCE_NAME = P_SOURCE;

Line: 307

      SELECT
        USER_JE_CATEGORY_NAME
      INTO JRNL_CATEGORY_PARAM
      FROM
        GL_JE_CATEGORIES
      WHERE JE_CATEGORY_NAME = P_CATEGORY;

Line: 316

      SELECT
        NAME
      INTO DOC_SEQ_NAME_PARAM
      FROM
        FND_DOCUMENT_SEQUENCES
      WHERE DOC_SEQUENCE_ID = P_DOC_SEQ_NAME;

Line: 356

    SELECT
      NAME,
      LTRIM(ADDRESS_LINE_1),
      LTRIM(ADDRESS_LINE_2),
      LTRIM(ADDRESS_LINE_3),
      LTRIM(TOWN_OR_CITY),
      LTRIM(POSTAL_CODE),
      ACTIVITY_CODE,
      REGISTRATION_NUMBER
    INTO TEMP_LE_NAME,TEMP_ADDR1,TEMP_ADDR2,TEMP_ADDR3,TEMP_TOWN_CITY,TEMP_POSTAL_CODE,TEMP_SERVICE_TYPE,TEMP_TAX_PAYER_ID
    FROM
      XLE_FIRSTPARTY_INFORMATION_V
    WHERE LEGAL_ENTITY_ID = V_LE_ID;

Line: 471

    SELECT
      PER.PERIOD_YEAR * 10000 + PER.PERIOD_NUM
    INTO EPERNUM
    FROM
      GL_ACCESS_SETS AC,
      GL_PERIODS PER
    WHERE AC.ACCESS_SET_ID = ACC_SET_ID
      AND PER.PERIOD_SET_NAME = AC.PERIOD_SET_NAME
      AND PER.PERIOD_NAME = PNAME;

Line: 497

        SELECT
          GLCD.OBJECT_ID
        INTO L_LEGAL_ID
        FROM
          GL_LEDGER_CONFIG_DETAILS GLCD
        WHERE GLCD.CONFIGURATION_ID = CONFIGURATION_ID_V
          AND GLCD.OBJECT_TYPE_CODE = 'LEGAL_ENTITY';

Line: 505

        SELECT
          GLNS.LEGAL_ENTITY_ID
        INTO L_LEGAL_ID
        FROM
          GL_LEDGER_NORM_SEG_VALS GLNS
        WHERE glns.ledger_id (+) = LEDGER_ID_V
          AND glns.segment_type_code (+) = 'B'
          AND glns.segment_value (+) = BALANCING_SEGMENT_VALUE
          AND NVL(status_code (+),
            'I') <> 'D';

Line: 562

  FUNCTION SELECT_ACCOUNT_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ACCOUNT;

Line: 565

  END SELECT_ACCOUNT_P;

Line: 567

  FUNCTION SELECT_ACCT_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ACCT_SEG;

Line: 570

  END SELECT_ACCT_SEG_P;

Line: 572

  FUNCTION SELECT_BAL_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_BAL_SEG;

Line: 575

  END SELECT_BAL_SEG_P;

Line: 622

  FUNCTION SELECT_IC_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_IC_SEG;

Line: 625

  END SELECT_IC_SEG_P;

Line: 627

  FUNCTION SELECT_MGT_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_MGT_SEG;

Line: 630

  END SELECT_MGT_SEG_P;

Line: 632

  FUNCTION SELECT_ST_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ST_SEG;

Line: 635

  END SELECT_ST_SEG_P;

Line: 637

  FUNCTION SELECT_LE_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_LE;

Line: 640

  END SELECT_LE_P;

Line: 682

  FUNCTION SELECT_CC_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_CC_SEG;

Line: 685

  END SELECT_CC_SEG_P;

Line: 767

  FUNCTION SELECT_DR_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_DR;

Line: 770

  END SELECT_DR_P;

Line: 772

  FUNCTION SELECT_CR_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_CR;

Line: 775

  END SELECT_CR_P;

Line: 777

  FUNCTION SELECT_BEGIN_BAL_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_BEGIN_BAL;

Line: 780

  END SELECT_BEGIN_BAL_P;