APPS.CSF_TRIPS_PUB dependencies on JTF_TASK_TYPES_VL

Line 300: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;

296: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
297: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
298:
299: SELECT name INTO g_dep_task_name
300: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;
301:
302: SELECT name INTO g_arr_task_name
303: FROM jtf_task_types_vl WHERE task_type_id = g_arr_task_type_id;
304:

Line 303: FROM jtf_task_types_vl WHERE task_type_id = g_arr_task_type_id;

299: SELECT name INTO g_dep_task_name
300: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;
301:
302: SELECT name INTO g_arr_task_name
303: FROM jtf_task_types_vl WHERE task_type_id = g_arr_task_type_id;
304:
305: --EXECUTE IMMEDIATE 'alter session set timed_statistics=true';
306: --EXECUTE IMMEDIATE 'alter session set statistics_level=all';
307: --EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever, level 12''';