653:
654: l_time_zone_id hz_timezones.timezone_id%TYPE;
655:
656: CURSOR c_time_zone_id IS
657: /* Bug 7290999 (changed reference from hz_timezones_vl to fnd_timezones_vl)
658: SELECT timezone_id
659: FROM hz_timezones
660: WHERE timezone_id = p_time_zone_id;
661: */
659: FROM hz_timezones
660: WHERE timezone_id = p_time_zone_id;
661: */
662: SELECT upgrade_tz_id
663: FROM fnd_timezones_vl
664: WHERE upgrade_tz_id = p_time_zone_id;
665:
666: BEGIN
667: