APPS.PA_PAXPCIDF_XMLP_PKG SQL Statements

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

Line: 32

          SELECT
            MEANING
          INTO ENTER_PARAM
          FROM
            PA_LOOKUPS
          WHERE LOOKUP_TYPE = 'ENTER VALUE'
            AND LOOKUP_CODE = 'ENTER_ORG_MGR';

Line: 51

          SELECT
            INITCAP(INVOICE_STATUS)
          INTO INV_STAT
          FROM
            DUAL;

Line: 68

          SELECT
            MEANING
          INTO REL_STAT
          FROM
            FND_LOOKUPS
          WHERE LOOKUP_TYPE = 'YES_NO'
            AND LOOKUP_CODE = INCLUDE_RELEASED_STATUS;

Line: 87

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

Line: 107

          SELECT
            FULL_NAME
          INTO MEMBER_NAME
          FROM
            PER_PEOPLE_F
          WHERE PERSON_ID = PROJECT_MEMBER
            AND sysdate between EFFECTIVE_START_DATE
            AND NVL(EFFECTIVE_END_DATE
             ,SYSDATE + 1)
            AND ( CURRENT_NPW_FLAG = 'Y'
          OR CURRENT_EMPLOYEE_FLAG = 'Y' )
            AND DECODE(CURRENT_NPW_FLAG
                ,'Y'
                ,NPW_NUMBER
                ,EMPLOYEE_NUMBER) IS NOT NULL;

Line: 134

          SELECT
            MEANING
          INTO ROLE_TYPE
          FROM
            PA_PROJECT_ROLE_TYPES
          WHERE PROJECT_ROLE_TYPE = PROJECT_ROLE_TYPE;

Line: 172

        SELECT
          MEANING
        INTO NDF
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
          AND LOOKUP_TYPE = 'MESSAGE';

Line: 190

        SELECT
          MEANING
        INTO NDF
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
          AND LOOKUP_TYPE = 'MESSAGE';

Line: 210

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

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

Line: 237

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