APPS.WF_MAIL_UTIL dependencies on FND_TIMEZONES_VL

Line 145: l_tz_code FND_TIMEZONES_VL.NAME%TYPE;

141: -- l_GMT_deviation - GMT deviation in varchar2 format
142: function getGMTDeviation(pName in varchar2) return varchar2
143: is
144: l_gmt_deviation varchar2(240);
145: l_tz_code FND_TIMEZONES_VL.NAME%TYPE;
146: begin
147: SELECT TIMEZONE_CODE
148: INTO l_tz_code
149: FROM FND_TIMEZONES_VL

Line 149: FROM FND_TIMEZONES_VL

145: l_tz_code FND_TIMEZONES_VL.NAME%TYPE;
146: begin
147: SELECT TIMEZONE_CODE
148: INTO l_tz_code
149: FROM FND_TIMEZONES_VL
150: WHERE NAME=pName;
151: SELECT '(GMT ' ||rtrim(TZ_OFFSET(l_tz_code),chr(0))|| ') '|| pName
152: INTO l_gmt_deviation
153: FROM dual;