APPS.PA_PAXPEEMO_XMLP_PKG SQL Statements

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

Line: 26

        SELECT
          SUBSTR(NAME
                ,1
                ,60)
        INTO ORG_NAME
        FROM
          HR_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = P_START_ORGANIZATION_ID;

Line: 37

        SELECT
          NAME
        INTO JOB_NAME
        FROM
          PER_JOBS
        WHERE JOB_ID = JOB_ID;

Line: 61

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

    SELECT
      DECODE(P_START_ORGANIZATION_ID
            ,NULL
            ,START_ORGANIZATION_ID
            ,P_START_ORGANIZATION_ID)
    INTO C_START_ORGANIZATION_ID
    FROM
      PA_IMPLEMENTATIONS;

Line: 86

    INSERT INTO PA_ORG_REPORTING_SESSIONS
      (START_ORGANIZATION_ID
      ,SESSION_ID)
    VALUES   (C_START_ORGANIZATION_ID
      ,USERENV('SESSIONID'));