APPS.PA_PAXPRFRP_XMLP_PKG SQL Statements

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

Line: 64

    SELECT
      GLB.NAME
    INTO V_COMPANY_NAME
    FROM
      GL_SETS_OF_BOOKS GLB,
      PA_IMPLEMENTATIONS PI
    WHERE GLB.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;

Line: 81

    SELECT
      MEANING
    INTO V_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_BASELINE_FLAG;

Line: 98

    SELECT
      PROJECT_TYPE
    INTO V_PROJECT_TYPE
    FROM
      PA_PROJECT_TYPES
    WHERE PROJECT_TYPE_ID = P_PROJECT_TYPE_ID
      AND DIRECT_FLAG = 'Y'
      AND SYSDATE between START_DATE_ACTIVE
      AND NVL(END_DATE_ACTIVE
       ,SYSDATE);

Line: 118

    SELECT
      USER_CONVERSION_TYPE
    INTO V_RATE_TYPE
    FROM
      PA_CONVERSION_TYPES_V
    WHERE CONVERSION_TYPE = P_RATE_TYPE;

Line: 135

    SELECT
      SEGMENT1
    INTO V_PROJECT_NUMBER
    FROM
      PA_PROJECTS
    WHERE PROJECT_ID = P_PROJECT_ID;