322: ;
323: Cursor c_res_tz
324: IS
325: SELECT ACTIVE_TIMEZONE_CODE,ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
326: FROM fnd_timezones_vl ft
327: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
328:
329:
330:
907: ;
908: Cursor c_res_tz
909: IS
910: SELECT ACTIVE_TIMEZONE_CODE,ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
911: FROM fnd_timezones_vl ft
912: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
913:
914:
915: