DBA Data[Home] [Help]

APPS.PA_PAXMGTSD_XMLP_PKG SQL Statements

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

Line: 34

        SELECT
          SUBSTR(NAME
                ,1
                ,60)
        INTO P_ORG
        FROM
          HR_ORGANIZATION_UNITS
        WHERE TASK_ORG = ORGANIZATION_ID;
Line: 45

        SELECT
          FULL_NAME
        INTO P_MGR
        FROM
          PER_PEOPLE_F
        WHERE TASK_MGR = PERSON_ID
          AND sysdate between EFFECTIVE_START_DATE
          AND NVL(EFFECTIVE_END_DATE
           ,SYSDATE + 1)
          AND EMPLOYEE_NUMBER IS NOT NULL;
Line: 58

        SELECT
          SEGMENT1,
          NAME
        INTO P_NUMBER,P_NAME
        FROM
          PA_PROJECTS
        WHERE PROJ = PROJECT_ID;
Line: 69

        SELECT
          TASK_NUMBER,
          TASK_NAME
        INTO TSK_NUM,TSK_NAME
        FROM
          PA_TASKS
        WHERE TASK = TASK_ID;
Line: 86

        SELECT
          BUDGET_TYPE_CODE,
          BUDGET_TYPE
        INTO P_COST_BGT_CODE,P_COST_BGT_TYPE
        FROM
          PA_BUDGET_TYPES
        WHERE BUDGET_AMOUNT_CODE = 'C'
          AND PREDEFINED_FLAG = 'Y'
          AND BUDGET_TYPE_CODE = 'AC';
Line: 98

        SELECT
          BUDGET_TYPE
        INTO P_COST_BGT_TYPE
        FROM
          PA_BUDGET_TYPES
        WHERE BUDGET_TYPE_CODE = COST_BGT_CODE;
Line: 108

        SELECT
          BUDGET_TYPE_CODE,
          BUDGET_TYPE
        INTO P_REV_BGT_CODE,P_REV_BGT_TYPE
        FROM
          PA_BUDGET_TYPES
        WHERE BUDGET_AMOUNT_CODE = 'R'
          AND PREDEFINED_FLAG = 'Y'
          AND BUDGET_TYPE_CODE = 'AR';
Line: 120

        SELECT
          BUDGET_TYPE
        INTO P_REV_BGT_TYPE
        FROM
          PA_BUDGET_TYPES
        WHERE BUDGET_TYPE_CODE = REV_BGT_CODE;
Line: 139

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

    SELECT
      MEANING
    INTO MESSAGE_NAME
    FROM
      PA_LOOKUPS
    WHERE LOOKUP_TYPE = 'MESSAGE'
      AND LOOKUP_CODE = 'NO_DATA_FOUND';
Line: 176

      SELECT
        PERIOD_NAME,
        START_DATE,
        END_DATE
      INTO PERNAME,ST_DATE,E_DATE
      FROM
        PA_PERIODS
      WHERE TRUNC(SYSDATE) between TRUNC(START_DATE)
        AND TRUNC(END_DATE);
Line: 186

      SELECT
        PERIOD_NAME,
        START_DATE,
        END_DATE
      INTO PERNAME,ST_DATE,E_DATE
      FROM
        PA_PERIODS
      WHERE PERIOD_NAME = PA_PERIOD;
Line: 272

    SELECT
      START_DATE,
      END_DATE
    INTO L_PRD_START_DATE,L_PRD_END_DATE
    FROM
      PA_PERIODS
    WHERE PERIOD_NAME = GET_PERIOD_AMT.PERIOD_NAME
      AND PERIOD_NAME IS NOT NULL;