2371:
2372: FUNCTION get_assignment(p_task_id number)
2373: return date IS
2374: cursor c_minutes is
2375: SELECT fnd_profile.value('CSF_UOM_MINUTES') minutes
2376: FROM dual;
2377:
2378: cursor c_task_assignment is
2379: select jta.last_update_date,
2683: l_msg_count NUMBER := 0;
2684: l_msg_data VARCHAR2(500);
2685: l_dest_day_time DATE;
2686: BEGIN
2687: IF ((nvl(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'), 'N') = 'Y') AND
2688: p_source_tz_id <> p_dest_tz_id) THEN
2689: HZ_TIMEZONE_PUB.Get_Time(p_api_version => 1.0,
2690: p_init_msg_list => 'F',
2691: p_source_tz_id => p_source_tz_id,