APPS.HZ_POPULATE_TIMEZONE_PKG SQL Statements

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

Line: 111

		select timezone_id
		from hz_phone_country_codes
		where phone_country_code = p_phone_country_code;

Line: 116

		select timezone_id
		from hz_phone_country_codes
		where territory_code = p_country_code
		and phone_country_code = p_phone_country_code;

Line: 122

		select count(*)
		from hz_phone_country_codes
		where phone_country_code = p_phone_country_code;

Line: 127

		select timezone_id
		from hz_phone_area_codes
		where phone_country_code = p_phone_country_code
		and area_code = p_area_code;

Line: 133

		select count(*)
		from hz_phone_area_codes
		where phone_country_code = p_phone_country_code
		and area_code = p_area_code;

Line: 139

		select timezone_id
		from hz_phone_area_codes
		where phone_country_code = p_phone_country_code
		and area_code = p_area_code
		and territory_code = p_country_code;

Line: 244

	  SELECT contact_point_id, phone_country_code, phone_area_code
          FROM hz_contact_points cp
          WHERE contact_point_type = 'PHONE';

Line: 249

	  SELECT contact_point_id, phone_country_code, phone_area_code
          FROM hz_contact_points cp
          WHERE contact_point_type = 'PHONE'
	  and timezone_id is null;

Line: 285

    /* for each phone we selected */
    OPEN phone_csr;

Line: 316

           UPDATE hz_contact_points
             SET timezone_id = l_timezone_id
           WHERE contact_point_id = I_CONTACT_POINT_ID(i);

Line: 366

           UPDATE hz_contact_points
             SET timezone_id = l_timezone_id
           WHERE contact_point_id = I_CONTACT_POINT_ID(i);

Line: 399

		select location_id, country, state, city, postal_code
		from hz_locations;

Line: 403

		select location_id, country, state, city, postal_code
		from hz_locations
		where timezone_id is null;

Line: 440

    /* for each location we selected */
    OPEN location_csr;

Line: 471

      UPDATE hz_locations
             SET timezone_id = l_timezone_id
           WHERE location_id = I_LOCATION_ID(i);

Line: 521

     UPDATE hz_locations
             SET timezone_id = l_timezone_id
           WHERE location_id = I_LOCATION_ID(i);