APPS.CSF_TASKS_PUB dependencies on JTF_TASK_TYPES_B

Line 75: FROM jtf_task_types_b

71: FUNCTION has_field_service_rule (p_task_type_id NUMBER)
72: RETURN VARCHAR2 IS
73: CURSOR c_task_type IS
74: SELECT task_type_id
75: FROM jtf_task_types_b
76: WHERE rule = 'DISPATCH'
77: AND NVL (schedule_flag, 'N') = 'Y'
78: AND task_type_id = p_task_type_id;
79: BEGIN

Line 742: , jtf_task_types_b tt

738: , ta.resource_name
739: FROM jtf_tasks_b t
740: , csf_ct_task_assignments ta
741: , jtf_task_statuses_vl ts
742: , jtf_task_types_b tt
743: WHERE t.ROWID = CHARTOROWID (p_row_id)
744: AND ts.task_status_id = t.task_status_id
745: AND tt.task_type_id = t.task_type_id
746: AND ta.task_id (+) = t.task_id;