APPS.PA_PACCGLER_XMLP_PKG SQL Statements

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

Line: 12

    SELECT
      ORG_ID,
      SET_OF_BOOKS_ID
    INTO P_ORG_ID,P_SOB_ID
    FROM
      PA_IMPLEMENTATIONS;

Line: 18

    SELECT
      START_DATE,
      END_DATE
    INTO P_FIRST_DATE,P_LAST_DATE
    FROM
      GL_PERIOD_STATUSES
    WHERE APPLICATION_ID = 101
      AND SET_OF_BOOKS_ID = P_SOB_ID
      AND PERIOD_NAME = P_GL_PERIOD;

Line: 45

    SELECT
      GL.NAME
    INTO L_NAME
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS PI
    WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;

Line: 67

      SELECT
        MEANING
      INTO L_TRAN_TYPE
      FROM
        PA_LOOKUPS
      WHERE LOOKUP_TYPE = 'PROJECT PROCESS ENTITIES'
        AND LOOKUP_CODE = P_TRAN_TYPE;

Line: 83

    SELECT
      NAME
    INTO L_LEGAL_ENTITY_NAME
    FROM
      XLE_ENTITY_PROFILES XEP,
      HR_ORGANIZATION_INFORMATION HRI
    WHERE LEGAL_ENTITY_ID = HRI.ORG_INFORMATION2
      AND ORGANIZATION_ID = P_ORG_ID
      AND ORG_INFORMATION_CONTEXT = 'Operating Unit Information';

Line: 101

    SELECT
      GL.CURRENCY_CODE
    INTO L_CURR_CODE
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS IMP
    WHERE IMP.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID;