APPS.PA_PAXPEORG_XMLP_PKG SQL Statements

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

Line: 6

    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: 29

        SELECT
          MEANING
        INTO ORG_TYPE_NAME
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_CODE = P_TYPE
          AND LOOKUP_TYPE = 'ORG_TYPE';