APPS.PA_PAXBUBSS_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 ORG = ORGANIZATION_ID;

Line: 45

        SELECT
          SUBSTR(FULL_NAME
                ,1
                ,30)
        INTO P_MGR
        FROM
          PER_PEOPLE_F
        WHERE MGR = PERSON_ID
          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: 65

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

Line: 76

        SELECT
          TASK_NUMBER,
          TASK_NAME
        INTO TSK_NUM,TSK_NAME
        FROM
          PA_TASKS
        WHERE TOPTASK = TASK_ID;

Line: 87

        SELECT
          MEANING
        INTO EXPLODE
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'YES_NO'
          AND LOOKUP_CODE = EXPLODE_SUB_TASKS;

Line: 97

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

        SELECT
          BUDGET_TYPE
        INTO P_COST_BGT_TYPE
        FROM
          PA_BUDGET_TYPES
        WHERE BUDGET_TYPE_CODE = COST_BGT_CODE;

Line: 119

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

        SELECT
          BUDGET_TYPE
        INTO P_REV_BGT_TYPE
        FROM
          PA_BUDGET_TYPES
        WHERE BUDGET_TYPE_CODE = REV_BGT_CODE;

Line: 152

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

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

Line: 184

    SELECT
      SUM(AR.ACCTD_AMOUNT_DUE_REMAINING)
    INTO ACCREC
    FROM
      AR_PAYMENT_SCHEDULES AR,
      RA_CUSTOMER_TRX TRX,
      PA_DRAFT_INVOICES PDI
    WHERE PDI.SYSTEM_REFERENCE = TRX.CUSTOMER_TRX_ID
      AND TRX.TRX_NUMBER = AR.TRX_NUMBER
      AND PDI.PROJECT_ID = PROJECT_ID_1;