APPS.CSF_TRIPS_PUB dependencies on JTF_TASK_TYPES_VL

Line 342: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;

338: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
339: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
340:
341: SELECT name INTO g_dep_task_name
342: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;
343:
344: SELECT name INTO g_arr_task_name
345: FROM jtf_task_types_vl WHERE task_type_id = g_arr_task_type_id;
346:

Line 345: FROM jtf_task_types_vl WHERE task_type_id = g_arr_task_type_id;

341: SELECT name INTO g_dep_task_name
342: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;
343:
344: SELECT name INTO g_arr_task_name
345: FROM jtf_task_types_vl WHERE task_type_id = g_arr_task_type_id;
346:
347: --EXECUTE IMMEDIATE 'alter session set timed_statistics=true';
348: --EXECUTE IMMEDIATE 'alter session set statistics_level=all';
349: --EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever, level 12''';