APPS.HZ_TIMEZONE_PUB SQL Statements

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

Line: 82

   SELECT timezone_id
   INTO   x_timezone_id
   FROM   HZ_TIMEZONE_MAPPING
   WHERE  postal_code = p_postal_code
   AND    country = p_country;

Line: 97

	 SELECT timezone_id
 	 INTO   x_timezone_id
 	 FROM   HZ_TIMEZONE_MAPPING
 	 WHERE  postal_code = p_postal_code
 	 AND	upper(city) = upper(p_city)
 	 AND    state is null
 	 AND    country = p_country;

Line: 106

 	   SELECT timezone_id
 	   INTO   x_timezone_id
 	   FROM   HZ_TIMEZONE_MAPPING
 	   WHERE postal_code is null
 	   AND	upper(city) = upper(p_city)
 	   AND    state is null
 	   AND    country = p_country;

Line: 115

 	     SELECT timezone_id
 	     INTO   x_timezone_id
 	     FROM   HZ_TIMEZONE_MAPPING
 	     WHERE  postal_code is null
 	     AND    city is null
 	     AND    state is null
 	     AND    country = p_country;

Line: 151

 	 SELECT timezone_id
 	 INTO   x_timezone_id
 	 FROM   HZ_TIMEZONE_MAPPING
 	 WHERE  postal_code = p_postal_code
 	 AND	upper(city) = upper(p_city)
 	 AND    state = p_state
 	 AND    country = p_country;

Line: 160

 	   SELECT timezone_id
 	   INTO   x_timezone_id
 	   FROM   HZ_TIMEZONE_MAPPING
 	   WHERE postal_code is null
 	   AND	upper(city) = upper(p_city)
 	   AND    state = p_state
 	   AND    country = p_country;

Line: 169

 	     SELECT timezone_id
 	     INTO   x_timezone_id
 	     FROM   HZ_TIMEZONE_MAPPING
 	     WHERE  postal_code is null
 	     AND    city is null
 	     AND    state = p_state
 	     AND    country = p_country;

Line: 178

 	     SELECT timezone_id
 	     INTO   x_timezone_id
 	     FROM   HZ_TIMEZONE_MAPPING
 	     WHERE  postal_code is null
 	     AND    city is null
 	     AND    state is null
 	     AND    country = p_country;

Line: 312

		select timezone_id
		from hz_phone_country_codes
		where phone_country_code = p_phone_country_code;

Line: 317

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

Line: 323

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

Line: 328

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

Line: 334

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

Line: 340

		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: 568

  SELECT H.GLOBAL_TIMEZONE_NAME,
	 F.NAME,
	 F.GMT_OFFSET,
	 F.DAYLIGHT_SAVINGS_FLAG,
	 F.TIMEZONE_CODE
  INTO   x_global_timezone_name,
	 x_name,
	 l_GMT_deviation,
	 l_dst_flag,
	 l_timezone_code
  FROM 	 HZ_TIMEZONES H, FND_TIMEZONES_VL F
  WHERE  H.timezone_id = p_timezone_id
    AND  H.timezone_id = F.upgrade_tz_id;

Line: 687

 	SELECT timezone_code
	  INTO l_dest_tz_code
	  FROM fnd_timezones_b
	 WHERE upgrade_tz_id = p_dest_tz_id;

Line: 692

 	SELECT timezone_code
	  INTO l_source_tz_code
	  FROM fnd_timezones_b
	 WHERE upgrade_tz_id = p_source_tz_id;

Line: 912

    SELECT GMT_DEVIATION_HOURS,
           STANDARD_TIME_SHORT_CODE,
           DAYLIGHT_SAVINGS_SHORT_CODE
    INTO   std_GMT_deviation,
           l_standard_short_code,
	   l_daylight_short_code
    FROM   HZ_TIMEZONES
    WHERE  timezone_id =  p_dest_tz_id;

Line: 1062

        select  h.timezone_id,
		f.name,
		f.timezone_code
        into    x_timezone_id,
                x_timezone_name,
                x_timezone_code
        from    hz_timezones_vl h, fnd_timezones_vl f
        where   h.timezone_id = f.upgrade_tz_id
	  and   h.gmt_deviation_hours = p_gmt_deviation_hours
          and   h.daylight_savings_time_flag = p_daylight_savings_time_flag
	  and   nvl(h.begin_dst_month,'-99') =  nvl(p_begin_dst_month,'-99')
	  and   nvl(h.begin_dst_day,-99)   =	nvl(p_begin_dst_day,-99)
	  and   nvl(h.begin_dst_week_of_month,-99) = 	nvl(p_begin_dst_week_of_month,-99)
	  and   nvl(h.begin_dst_day_of_week,-99) = 	nvl(p_begin_dst_day_of_week,-99)
	  and   nvl(begin_dst_hour,-99)  = nvl(p_begin_dst_hour,-99)
	  and   nvl(h.end_dst_month,'-99') =  nvl(p_end_dst_month,'-99')
	  and   nvl(h.end_dst_day,-99)   =	nvl(p_end_dst_day,-99)
	  and   nvl(h.end_dst_week_of_month,-99) = 	nvl(p_end_dst_week_of_month,-99)
	  and   nvl(h.end_dst_day_of_week,-99) = 	nvl(p_end_dst_day_of_week,-99)
	  and   nvl(end_dst_hour,-99) = nvl(p_end_dst_hour,-99)
          and   h.primary_zone_flag = 'Y';

Line: 1221

    SELECT F.GMT_OFFSET,
           H.STANDARD_TIME_SHORT_CODE,
           H.DAYLIGHT_SAVINGS_SHORT_CODE,
           F.NAME,
	   F.TIMEZONE_CODE
    INTO   l_gmt_deviation,
           l_standard_short_code,
	   l_daylight_short_code,
           x_name,
	   l_timezone_code
    FROM   HZ_TIMEZONES_VL H, FND_TIMEZONES_VL F
    WHERE  H.timezone_id =  p_timezone_id
      AND  H.timezone_id =  F.upgrade_tz_id;

Line: 1244

	    SELECT f.GMT_OFFSET,
           	   h.STANDARD_TIME_SHORT_CODE,
           	   h.DAYLIGHT_SAVINGS_SHORT_CODE,
           	   f.NAME
    	   INTO    l_gmt_deviation,
           	   l_standard_short_code,
	   	   l_daylight_short_code,
           	   x_name
     	   FROM    FND_TIMEZONES_VL f, HZ_TIMEZONES_VL h
    	  WHERE    f.timezone_code =  p_timezone_code
            AND    f.upgrade_tz_id = h.timezone_id;

Line: 1366

  SELECT DAYLIGHT_SAVINGS_TIME_FLAG,
	 LPAD(BEGIN_DST_MONTH,2,'0'),
	 BEGIN_DST_DAY,
	 BEGIN_DST_WEEK_OF_MONTH,
	 BEGIN_DST_DAY_OF_WEEK,
	 BEGIN_DST_HOUR,
	 LPAD(END_DST_MONTH,2,'0'),
	 END_DST_DAY,
	 END_DST_WEEK_OF_MONTH,
	 END_DST_DAY_OF_WEEK,
 	 END_DST_HOUR
  INTO   v_dst_flag,
	 v_begin_dst_month,
	 v_begin_dst_day,
  	 v_begin_dst_week_of_m,
 	 v_begin_dst_day_of_w,
  	 v_begin_dst_hour,
  	 v_end_dst_month,
  	 v_end_dst_day,
  	 v_end_dst_week_of_m,
  	 v_end_dst_day_of_w,
  	 v_end_dst_hour
  FROM 	 HZ_TIMEZONES_VL
  WHERE  timezone_id = p_timezone_id;

Line: 1578

    select to_char(l_date, 'W'),
	   to_char(l_date, 'D')
    into   l_week_of_m,
	   l_day_of_w
    from   sys.dual;