APPS.PSP_PSPRCDLS_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      ASSIGNMENT_NUMBER
    INTO X_ASSIGNMENT_NUMBER
    FROM
      PER_ASSIGNMENTS_F
    WHERE ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID
      AND ASSIGNMENT_TYPE = 'E'
      AND ROWNUM < 2;

Line: 29

    SELECT
      FULL_NAME
    INTO X_PERSON_NAME
    FROM
      PER_PEOPLE_F
    WHERE PERSON_ID = CF_PERSON_NAMEFORMULA.PERSON_ID
      AND P_END_DATE BETWEEN EFFECTIVE_START_DATE
      AND EFFECTIVE_END_DATE;

Line: 49

    SELECT
      END_DATE
    INTO P_END_DATE
    FROM
      PER_TIME_PERIODS
    WHERE TIME_PERIOD_ID = P_TIME_PERIOD_ID;

Line: 60

                 ,'End Date not found for the selected time period id')*/NULL;

Line: 64

                 ,'Too many rows found for the selected time period id')*/NULL;

Line: 142

        SELECT
          NAME
        INTO L_PROJECT_NAME
        FROM
          PA_PROJECTS_ALL
        WHERE PROJECT_ID = CF_CHARGING_INSTRUCTIONSFORMUL.PROJECT_ID;

Line: 148

        SELECT
          TASK_NUMBER
        INTO L_TASK_NUMBER
        FROM
          PA_TASKS_EXPEND_V  -- Bug : 16391366  (20/03/2013)
        WHERE TASK_ID = CF_CHARGING_INSTRUCTIONSFORMUL.TASK_ID;

Line: 155

          SELECT
            AWARD_NUMBER
          INTO L_AWARD_NUMBER
          FROM
            GMS_AWARDS_ALL
          WHERE AWARD_ID = CF_CHARGING_INSTRUCTIONSFORMUL.AWARD_ID;

Line: 164

        SELECT
          NAME
        INTO L_ORG_NAME
        FROM
          HR_ALL_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = CF_CHARGING_INSTRUCTIONSFORMUL.EXPENDITURE_ORGANIZATION_ID;

Line: 185

      SELECT
        NAME
      INTO X_ORG_NAME
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = TO_NUMBER(X_ORG_ID);

Line: 209

      SELECT
        PERIOD_NAME
      INTO X_TIME_PERIOD
      FROM
        PER_TIME_PERIODS
      WHERE TIME_PERIOD_ID = P_TIME_PERIOD_ID;

Line: 223

    SELECT
      MEANING
    INTO X_SOURCE_TYPE
    FROM
      PSP_LOOKUPS
    WHERE LOOKUP_TYPE = 'PSP_SOURCE_TYPE'
      AND LOOKUP_CODE = P_SOURCE_TYPE;

Line: 248

      SELECT
        SUM(DECODE(A.DR_CR_FLAG
                  ,'C'
                  ,B.DISTRIBUTION_AMOUNT
                  ,0)) DL_CREDIT_AMOUNT,
        SUM(DECODE(A.DR_CR_FLAG
                  ,'D'
                  ,B.DISTRIBUTION_AMOUNT
                  ,0)) DL_DEBIT_AMOUNT,
        B.SUSPENSE_REASON_CODE
      FROM
        PSP_SUMMARY_LINES A,
        PSP_PAYROLL_CONTROLS PPC,
        PSP_DISTRIBUTION_LINES_HISTORY B
      WHERE A.SUMMARY_LINE_ID = B.SUMMARY_LINE_ID
        AND PPC.PAYROLL_CONTROL_ID = A.PAYROLL_CONTROL_ID
        AND PPC.CURRENCY_CODE = CF_1FORMULA.CURRENCY_CODE
        AND A.STATUS_CODE = 'A'
        AND B.STATUS_CODE = 'A'
        AND A.SOURCE_TYPE = P_SOURCE_TYPE
        AND A.SOURCE_CODE = P_SOURCE_CODE
        AND A.TIME_PERIOD_ID = P_TIME_PERIOD_ID
        AND ( A.INTERFACE_BATCH_NAME = P_BATCH_NAME
      OR A.INTERFACE_BATCH_NAME IS NULL )
        AND A.PERSON_ID = CF_1FORMULA.PERSON_ID
        AND A.ASSIGNMENT_ID = CF_1FORMULA.ASSIGNMENT_ID
        AND A.GL_CODE_COMBINATION_ID = CF_1FORMULA.GL_CODE_COMBINATION_ID
      GROUP BY
        A.DR_CR_FLAG,
        B.SUSPENSE_REASON_CODE;

Line: 279

      SELECT
        SUM(DECODE(A.DR_CR_FLAG
                  ,'C'
                  ,B.DISTRIBUTION_AMOUNT
                  ,0)) DL_CREDIT_AMOUNT,
        SUM(DECODE(A.DR_CR_FLAG
                  ,'D'
                  ,B.DISTRIBUTION_AMOUNT
                  ,0)) DL_DEBIT_AMOUNT,
        B.SUSPENSE_REASON_CODE
      FROM
        PSP_SUMMARY_LINES A,
        PSP_PAYROLL_CONTROLS PPC,
        PSP_DISTRIBUTION_LINES_HISTORY B
      WHERE A.SUMMARY_LINE_ID = B.SUMMARY_LINE_ID
        AND PPC.PAYROLL_CONTROL_ID = A.PAYROLL_CONTROL_ID
        AND PPC.CURRENCY_CODE = CF_1FORMULA.CURRENCY_CODE
        AND A.STATUS_CODE = 'A'
        AND B.STATUS_CODE = 'A'
        AND A.SOURCE_TYPE = P_SOURCE_TYPE
        AND A.SOURCE_CODE = P_SOURCE_CODE
        AND A.TIME_PERIOD_ID = P_TIME_PERIOD_ID
        AND ( A.INTERFACE_BATCH_NAME = P_BATCH_NAME
      OR A.INTERFACE_BATCH_NAME IS NULL )
        AND A.PERSON_ID = CF_1FORMULA.PERSON_ID
        AND A.ASSIGNMENT_ID = CF_1FORMULA.ASSIGNMENT_ID
        AND A.PROJECT_ID = CF_1FORMULA.PROJECT_ID
        AND A.TASK_ID = CF_1FORMULA.TASK_ID
        AND ( A.AWARD_ID = CF_1FORMULA.AWARD_ID
      OR A.AWARD_ID IS NULL
        AND CF_1FORMULA.AWARD_ID IS NULL )
        AND A.EXPENDITURE_TYPE = CF_1FORMULA.EXPENDITURE_TYPE
        AND A.EXPENDITURE_ORGANIZATION_ID = CF_1FORMULA.EXPENDITURE_ORGANIZATION_ID
      GROUP BY
        A.DR_CR_FLAG,
        B.SUSPENSE_REASON_CODE;