APPS.PA_PAXPRTSK_XMLP_PKG SQL Statements

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

Line: 28

      SELECT
        DECODE(PA_INSTALL.IS_BILLING_LICENSED
              ,'Y'
              ,'N'
              ,'Y')
      INTO P_COSTING
      FROM
        DUAL;

Line: 42

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

Line: 52

        SELECT
          T.TASK_ID
        INTO P_TASK_ID
        FROM
          PA_TASKS T
        WHERE PROJECT_ID = PROJ
          AND DECODE(C_TOP_TASK_ID
              ,''
              ,T.PARENT_TASK_ID
              ,'All'
              ,T.PARENT_TASK_ID
              ,NULL) is null
          AND DECODE(C_TOP_TASK_ID
              ,''
              ,T.TASK_ID
              ,'All'
              ,T.TASK_ID
              ,C_TOP_TASK_ID) = T.TASK_ID;

Line: 73

        SELECT
          SUBSTR(MEANING
                ,1
                ,40)
        INTO DISP_SUBTASKS
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_CODE = C_DISPLAY_SUBTASKS
          AND LOOKUP_TYPE = 'YES_NO';

Line: 85

        SELECT
          SUBSTR(MEANING
                ,1
                ,40)
        INTO DISP_ST_DETAILS
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_CODE = C_DISPLAY_SUBTASK_DETAILS
          AND LOOKUP_TYPE = 'YES_NO';

Line: 97

        SELECT
          TASK_NAME,
          TASK_NUMBER
        INTO P_TASK_NAME,P_TASK_NUMBER
        FROM
          PA_TASKS
        WHERE TASK_ID = C_TOP_TASK_ID;

Line: 127

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

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

Line: 244

    SELECT
      MEANING
    INTO L_REASON
    FROM
      PA_LOOKUPS
    WHERE LOOKUP_TYPE = 'RATE AND DISCOUNT REASON'
      AND LOOKUP_CODE = JOB_DISC_REASON;

Line: 261

    SELECT
      MEANING
    INTO L_REASON
    FROM
      PA_LOOKUPS
    WHERE LOOKUP_TYPE = 'RATE AND DISCOUNT REASON'
      AND LOOKUP_CODE = NL_DISC_REASON;

Line: 278

    SELECT
      MEANING
    INTO L_REASON
    FROM
      PA_LOOKUPS
    WHERE LOOKUP_TYPE = 'RATE AND DISCOUNT REASON'
      AND LOOKUP_CODE = RATE_DISC_REASON_CODE;

Line: 297

      SELECT
        MEANING
      INTO TMP_FLAG
      FROM
        PA_LOOKUPS LKP,
        PA_PROJECTS PRJ
      WHERE LKP.LOOKUP_TYPE = 'REVENUE ACCRUAL METHOD'
        AND LKP.LOOKUP_CODE = PRJ.REVENUE_ACCRUAL_METHOD
        AND PRJ.PROJECT_ID = PROJECT_ID1;

Line: 320

      SELECT
        MEANING
      INTO TMP_FLAG
      FROM
        PA_LOOKUPS LKP,
        PA_PROJECTS PRJ
      WHERE LKP.LOOKUP_TYPE = 'INVOICE METHOD'
        AND LKP.LOOKUP_CODE = PRJ.INVOICE_METHOD
        AND PRJ.PROJECT_ID = PROJECT_ID1;

Line: 343

      SELECT
        CUSTOMER_NUMBER
      INTO TMP_FLAG
      FROM
        PA_PROJECT_CUSTOMERS_V
      WHERE PROJECT_ID = PROJECT_ID1
        AND CUSTOMER_ID = CUSTOMER_ID1;

Line: 364

      SELECT
        CUSTOMER_NAME
      INTO TMP_FLAG
      FROM
        PA_PROJECT_CUSTOMERS_V
      WHERE PROJECT_ID = PROJECT_ID1
        AND CUSTOMER_ID = CUSTOMER_ID1;