APPS.CS_TZ_GET_DETAILS_PVT dependencies on DUAL

Line 103: from dual;

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))
102: into l_e_GMT_dev
103: from dual;
104: -- End bug 11830349
105: X_GMT_DEV := l_e_GMT_dev;
106:
107: ELSIF (l_start_tz_id IS NOT NULL) THEN

Line 135: from dual;

131: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
132: || to_number(substr(tz_offset(l_timezone_code),2,2))
133: || 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))
134: into l_s_GMT_dev
135: from dual;
136: -- End bug 11830349
137: -- If time lag is null, then return the GMT offset of the Server time.
138:
139: IF (l_time_lag IS NOT NULL) THEN

Line 263: from dual;

259: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
260: || to_number(substr(tz_offset(l_timezone_code),2,2))
261: || 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))
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;

Line 273: from dual;

269: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
270: || to_number(substr(tz_offset(l_timezone_code),2,2))
271: || 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))
272: into l_e_GMT_dev
273: from dual;
274: -- End bug 11830349
275:
276: /* HZ_TIMEZONE_PUB.Get_Timezone_GMT_Deviation(p_api_version,
277: p_init_msg_list,

Line 468: from dual;

464: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
465: || to_number(substr(tz_offset(l_timezone_code),2,2))
466: || 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))
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;

Line 478: from dual;

474: select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
475: || to_number(substr(tz_offset(l_timezone_code),2,2))
476: || 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))
477: into l_e_GMT_dev
478: from dual;
479: -- End bug 11830349
480:
481: /* HZ_TIMEZONE_PUB.Get_Timezone_GMT_Deviation(p_api_version,
482: p_init_msg_list,