APPS.CSF_GANTT_DATA_PKG dependencies on FND_TIMEZONES_VL

Line 382: FROM fnd_timezones_vl ft

378: ;
379: Cursor c_res_tz
380: IS
381: 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
382: FROM fnd_timezones_vl ft
383: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
384:
385: Cursor c_trip
386: IS

Line 1521: FROM fnd_timezones_vl ft

1517: ;
1518: Cursor c_res_tz
1519: IS
1520: 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
1521: FROM fnd_timezones_vl ft
1522: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
1523:
1524: Cursor c_trip
1525: IS

Line 2491: FROM fnd_timezones_vl ft

2487: ;
2488: Cursor c_res_tz
2489: IS
2490: 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
2491: FROM fnd_timezones_vl ft
2492: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
2493:
2494: Cursor c_terr
2495: IS

Line 3218: FROM fnd_timezones_vl ft

3214: ;
3215: Cursor c_res_tz
3216: IS
3217: 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
3218: FROM fnd_timezones_vl ft
3219: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
3220:
3221: Cursor c_terr
3222: IS