APPS.PA_LOCATION_UTILS SQL Statements

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

Line: 60

                SELECT territory_code
                FROM   fnd_territories_vl
                WHERE  territory_short_name = p_country_name;

Line: 70

                        SELECT territory_code
                        INTO   x_country_code
                        FROM   fnd_territories
                        WHERE  territory_code = p_country_code;

Line: 118

                        SELECT territory_code
                        INTO   x_country_code
                        FROM   fnd_territories_vl
                        WHERE  territory_short_name = p_country_name;

Line: 189

           SELECT l.country,
                  t.territory_short_name,
                  l.town_or_city,
                  decode(l.region_2, NULL, l.region_1, l.region_2)
           INTO   x_country_code,
                  x_country_name,
                  x_city,
                  x_region
           FROM   hr_all_organization_units o, -- Bug 4684196
                  -- hr_organization_units o,
                  hr_locations_all l,
                  fnd_territories_vl t
           WHERE  t.territory_code = l.country
             AND  o.location_id = l.location_id
             AND  o.organization_id = p_organization_id ;

Line: 283

           SELECT l.country,
                  t.territory_short_name,
                  l.town_or_city,
                  decode(l.region_2, NULL, l.region_1, l.region_2)
           INTO   x_country_code,
                  x_country_name,
                  x_city,
                  x_region
           FROM   per_addresses l,
                  fnd_territories_vl t
           WHERE  t.territory_code = l.country
             AND  l.primary_flag = 'Y'
             AND  p_assign_date  between l.DATE_FROM and nvl(l.DATE_TO, p_assign_date)
             AND  l.person_id = p_person_id ;

Line: 365

           SELECT l.country_code,
                  t.territory_short_name,
                  l.city,
                  l.region
           INTO   x_country_code,
                  x_country_name,
                  x_city,
                  x_region
           FROM   pa_locations l,
                  fnd_territories_vl t
           WHERE  t.territory_code = l.country_code
             AND  l.location_id = p_location_id ;

Line: 427

         SELECT l.location_id
           INTO x_location_id
           FROM pa_locations l
          WHERE ( ( l.city = p_city)
                 OR (l.city IS NULL AND p_city IS NULL))
            AND ( (l.region = p_region)
                 OR (l.region IS NULL AND p_region IS NULL))
            AND l.country_code = p_country_code ;

Line: 508

                PA_LOCATIONS_PKG.INSERT_ROW (
                                    p_CITY               => p_city
                                  , p_REGION             => p_region
                                  , p_COUNTRY_CODE       => p_country_code
                                  , p_CREATION_DATE      => sysdate
                                  , p_CREATED_BY         => l_created_by
                                  , p_LAST_UPDATE_DATE   => sysdate
                                  , p_LAST_UPDATED_BY    => l_login_id
                                  , p_LAST_UPDATE_LOGIN  => l_login_id
                                  , X_ROWID              => l_ROW_ID
                                  , X_LOCATION_ID        => l_location_id );

Line: 560

   SELECT l.country_code,
          t.territory_short_name
   INTO   x_country_code,
          x_country_name
   FROM   pa_locations l,
          fnd_territories_vl t
   WHERE  t.territory_code = l.country_code
     AND  l.location_id = p_location_id;