APPS.PA_PROJECT_SET_UTILS SQL Statements

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

Line: 22

      SELECT employee_id, customer_id
      INTO l_employee_id, l_customer_id
      FROM fnd_user
      WHERE user_id = p_user_id;

Line: 28

      SELECT employee_id,person_party_id -- selecting person_party_id instead of customer_id
      INTO l_employee_id,l_customer_id
      from fnd_user
      WHERE user_id = p_user_id;

Line: 36

         SELECT hp.party_id, hp.party_name
         INTO x_party_id, x_party_name
         FROM per_all_people_f pap, hz_parties hp
         WHERE pap.person_id = l_employee_id
           AND pap.party_id  = hp.party_id
           AND rownum        = 1;

Line: 44

         SELECT party_id, party_name
         INTO x_party_id, x_party_name
         FROM hz_parties
         WHERE party_type   = 'PERSON'
           AND party_id     = l_customer_id
           AND rownum       = 1;

Line: 74

      SELECT project_set_id,
             project_id
      BULK COLLECT INTO
             l_project_set_id_tbl,
             l_project_id_tbl
      FROM pa_project_set_lines
      WHERE project_set_id = p_project_set_id;

Line: 104

   SELECT 'Y'
   FROM pa_project_set_lines
   WHERE project_set_id = p_project_set_id;

Line: 133

     SELECT 'Y' INTO l_exists
     FROM pa_project_set_lines
     WHERE project_set_id = p_project_set_id
       AND project_id     = p_project_id;

Line: 152

   l_update_sup_user  VARCHAR2(1);

Line: 157

   l_update_sup_user := PA_SECURITY_PVT.check_user_privilege(
                          p_privilege    => 'PA_PROJ_SET_UPDATE'
                         ,p_object_name  => null
                         ,p_object_key   => null);

Line: 162

   IF l_update_sup_user = 'T' THEN
         RETURN 'T';

Line: 189

   SELECT 'N'
   FROM pa_project_sets_tl
   WHERE name = p_project_set_name
     AND language = userenv('lang')
     AND ((project_set_id <> p_project_set_id AND p_project_set_id IS NOT NULL)
           OR p_project_set_id IS NULL);

Line: 222

  SELECT name
  INTO l_project_set_name
  FROM pa_project_sets_tl
  WHERE project_set_id = p_project_set_id
  AND userenv('lang')  = language(+);  --Bug 6208018

Line: 264

     SELECT name, segment1
     FROM pa_projects_all
     WHERE project_id = l_project_id;

Line: 353

       SELECT party_id
       INTO   x_party_id
       FROM   hz_parties
       WHERE  party_id = p_party_id;

Line: 361

     SELECT party_id
     INTO x_party_id
     FROM hz_parties
     WHERE party_name = p_party_name;

Line: 399

      SELECT project_set_id
      FROM pa_project_sets_vl
      WHERE upper(name) = upper(p_project_set_name);

Line: 406

      SELECT project_set_id
          INTO x_project_set_id
          FROM pa_project_sets_vl
          WHERE upper(name) = upper(p_project_set_name);

Line: 416

         SELECT project_set_id
         INTO x_project_set_id
         FROM pa_project_sets_vl
         WHERE project_set_id = p_project_set_id;

Line: 484

    SELECT orig_system_reference
    FROM hz_parties
    WHERE party_id = p_party_id;