DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on FND_TIMEZONES_VL

Line 3213: FROM FND_TIMEZONES_VL

3209: SELECT '(GMT ' ||
3210: rtrim(tz_offset(timezone_code),chr(0))
3211: || ') ' || name DISPLAYED_NAME
3212: , upgrade_tz_id PROFILE_VALUE
3213: FROM FND_TIMEZONES_VL
3214: WHERE enabled_flag = 'Y'
3215: ORDER BY gmt_offset, name;
3216:
3217:

Line 3275: FROM FND_TIMEZONES_VL

3271: rtrim(tz_offset(timezone_code),chr(0))
3272: || ') ' || name DISPLAYED_NAME
3273: INTO
3274: l_timezone_code
3275: FROM FND_TIMEZONES_VL
3276: WHERE enabled_flag = 'Y'
3277: AND upgrade_tz_id=l_timezone;
3278: EXCEPTION WHEN no_data_found THEN
3279: NULL;--what do we do here?