APPS.EDW_GEOGRAPHY_PKG SQL Statements

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

Line: 19

        select instance_code into l_instance
          from edw_local_instance;

Line: 50

      select city, postal_code, decode(state, null, province, state), country
      into   l_city, l_postal_code, l_state, l_country
      from   hz_locations
      where  location_id = p_location_id;

Line: 90

        select instance_code into l_instance
          from edw_local_instance;

Line: 95

      select party_site_id into l_party_site_id
        from HZ_CUST_ACCT_SITES_ALL     hcas,
             HZ_CUST_SITE_USES_ALL      hcsu
       where hcsu.site_use_id = p_site_use_id
         and hcsu.cust_acct_site_id = hcas.cust_acct_site_id;

Line: 134

        select instance_code into l_instance
          from edw_local_instance;

Line: 169

        select instance_code into l_instance
          from edw_local_instance;