DBA Data[Home] [Help]

APPS.CS_TZ_GET_DETAILS_PVT dependencies on FND_TIMEZONES_VL

Line 724: FROM fnd_timezones_vl

720:
721: -- Cursor to derive time zone name from time zone id
722: CURSOR timezone_name IS
723: SELECT name
724: FROM fnd_timezones_vl
725: WHERE upgrade_tz_id = l_tz_id ;
726:
727: l_task_timezone_id NUMBER ;
728: l_task_timezone VARCHAR2(50) ;

Line 1120: select timezone_code into l_tz_code from FND_TIMEZONES_VL where upgrade_tz_id = l_tx_id;

1116: , x_timezone_id => x_timezone_id
1117: , x_timezone_name => x_timezone_name);
1118:
1119: l_tx_id := x_timezone_id;
1120: select timezone_code into l_tz_code from FND_TIMEZONES_VL where upgrade_tz_id = l_tx_id;
1121: x_timezone_code := l_tz_code;
1122:
1123: END CUSTOMER_PREFERRED_TIME_ZONE;
1124: