APPS.OTA_LEARNER_ACCESS_UTIL dependencies on FND_TIMEZONES_B

Line 2200: p_server_timezone_code fnd_timezones_b.timezone_code%type) is

2196:
2197: CURSOR csr_classes_in_course(
2198: p_activity_version_id in ota_activity_versions.activity_version_id%type,
2199: p_business_group_id ota_events.business_group_id%type,
2200: p_server_timezone_code fnd_timezones_b.timezone_code%type) is
2201: SELECT OEV.event_id,
2202: OEV.public_event_flag,
2203: OEV.maximum_internal_attendees,
2204: OEV.course_start_date

Line 2227: p_server_timezone_code fnd_timezones_b.timezone_code%type) is

2223:
2224: CURSOR csr_normal_classes_in_course(
2225: p_activity_version_id in ota_activity_versions.activity_version_id%type,
2226: p_business_group_id ota_events.business_group_id%type,
2227: p_server_timezone_code fnd_timezones_b.timezone_code%type) is
2228: SELECT OEV.event_id,
2229: OEV.public_event_flag,
2230: OEV.maximum_internal_attendees,
2231: OEV.course_start_date

Line 2253: l_server_timezone_code fnd_timezones_b.timezone_code%type;

2249: AND nvl(OEV.event_availability, 'ALL') = 'ALL'
2250: ORDER BY OEV.public_event_flag DESC;
2251:
2252: l_business_group_id ota_events.business_group_id%type;
2253: l_server_timezone_code fnd_timezones_b.timezone_code%type;
2254: begin
2255:
2256: l_business_group_id := ota_general.get_business_group_id;
2257: l_server_timezone_code := ota_timezone_util.get_server_timezone_code;