APPS.PSP_PSPDAREG_XMLP_PKG SQL Statements

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

Line: 28

        SELECT
          NAME
        INTO L_PROJECT_NAME
        FROM
          PA_PROJECTS_ALL
        WHERE PROJECT_ID = PROJECT_ID_NEW;

Line: 34

        SELECT
          TASK_NUMBER
        INTO L_TASK_NUMBER
        FROM
          PA_TASKS
        WHERE TASK_ID = TASK_ID_NEW;

Line: 41

          SELECT
            AWARD_NUMBER
          INTO L_AWARD_NUMBER
          FROM
            GMS_AWARDS_ALL
          WHERE AWARD_ID = AWARD_ID_NEW;

Line: 50

        SELECT
          NAME
        INTO L_ORG_NAME
        FROM
          HR_ALL_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = EXP_ORG_ID_NEW;

Line: 89

        SELECT
          NAME
        INTO L_PROJECT_NAME
        FROM
          PA_PROJECTS_ALL
        WHERE PROJECT_ID = PROJECT_ID_OLD;

Line: 95

        SELECT
          TASK_NUMBER
        INTO L_TASK_NUMBER
        FROM
          PA_TASKS
        WHERE TASK_ID = TASK_ID_OLD;

Line: 102

          SELECT
            AWARD_NUMBER
          INTO L_AWARD_NUMBER
          FROM
            GMS_AWARDS_ALL
          WHERE AWARD_ID = AWARD_ID_OLD;

Line: 111

        SELECT
          NAME
        INTO L_ORG_NAME
        FROM
          HR_ALL_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = EXP_ORG_ID_OLD;

Line: 137

      SELECT
        PPX.FULL_NAME
      INTO V_FULLNAME
      FROM
        PER_PEOPLE_X PPX,
        FND_USER FU
      WHERE FU.USER_ID = P_APPROVED_BY
        AND PPX.PERSON_ID = FU.EMPLOYEE_ID;

Line: 158

      SELECT
        PPX.FULL_NAME
      INTO V_FULLNAME
      FROM
        PER_PEOPLE_X PPX,
        FND_USER FU
      WHERE FU.USER_ID = P_SUBMITTED_BY
        AND PPX.PERSON_ID = FU.EMPLOYEE_ID;

Line: 179

      SELECT
        NAME
      INTO V_ORGNAME
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ASSIGNMENT_ORGANIZATION_ID;

Line: 208

                                    		(SELECT person_id
                                    		 FROM 	per_all_assignments_f
                                    		 WHERE  organization_id = :P_PRIMARY_ORGANIZATION_ID
                                    		 AND   	primary_flag = ''Y''
                                    		 AND    trunc(sysdate) BETWEEN effective_start_date AND effective_end_date)';

Line: 223

      SELECT
        DISTINCT
        NAME
      INTO V_ORGNAME
      FROM
        HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_PRIMARY_ORGANIZATION_ID;

Line: 250

      SELECT
        LTRIM(MEANING)
      FROM
        FND_LOOKUP_VALUES
      WHERE LOOKUP_TYPE = 'PSP_MESSAGE_TEXT'
        AND LOOKUP_CODE = ADJUSTMENT_BY;