APPS.CS_TZ_GET_DETAILS_PVT dependencies on FND_TIMEZONES_B

Line 97: From fnd_timezones_b

93: END IF ;
94: */
95: -- Start bug 11830349
96: Select timezone_code Into l_timezone_code
97: From fnd_timezones_b
98: Where upgrade_tz_id = l_end_tz_id;
99: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
100: || to_number(substr(tz_offset(l_timezone_code),2,2))
101: || decode(to_number(substr(tz_offset(l_timezone_code),5,2))/60,0,null,to_number(substr(tz_offset(l_timezone_code),5,2))/60))

Line 128: From fnd_timezones_b

124: END IF ;
125: */
126: -- Start bug 11830349
127: Select timezone_code Into l_timezone_code
128: From fnd_timezones_b
129: Where upgrade_tz_id = l_start_tz_id;
130:
131: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
132: || to_number(substr(tz_offset(l_timezone_code),2,2))

Line 256: From fnd_timezones_b

252: -- in each Time zone and GMT. The return values l_s_GMT_dev and
253: -- l_e_GMT_dev store the time difference.
254: -- Start bug 11830349
255: Select timezone_code Into l_timezone_code
256: From fnd_timezones_b
257: Where upgrade_tz_id = l_start_tz_id;
258:
259: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
260: || to_number(substr(tz_offset(l_timezone_code),2,2))

Line 266: From fnd_timezones_b

262: into l_s_GMT_dev
263: from dual;
264:
265: Select timezone_code Into l_timezone_code
266: From fnd_timezones_b
267: Where upgrade_tz_id = l_end_tz_id;
268:
269: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
270: || to_number(substr(tz_offset(l_timezone_code),2,2))

Line 461: From fnd_timezones_b

457: -- each Time zone and GMT. The return values l_s_GMT_dev and
458: -- l_e_GMT_dev store the time difference.
459: -- Start bug 11830349
460: Select timezone_code Into l_timezone_code
461: From fnd_timezones_b
462: Where upgrade_tz_id = l_start_tz_id;
463:
464: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
465: || to_number(substr(tz_offset(l_timezone_code),2,2))

Line 471: From fnd_timezones_b

467: into l_s_GMT_dev
468: from dual;
469:
470: Select timezone_code Into l_timezone_code
471: From fnd_timezones_b
472: Where upgrade_tz_id = l_end_tz_id;
473:
474: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
475: || to_number(substr(tz_offset(l_timezone_code),2,2))