APPS.CSF_TASKS_PUB dependencies on JTF_TASK_TYPES_B

Line 125: FROM jtf_task_types_b

121: FUNCTION has_field_service_rule (p_task_type_id NUMBER)
122: RETURN VARCHAR2 IS
123: CURSOR c_task_type IS
124: SELECT task_type_id
125: FROM jtf_task_types_b
126: WHERE rule = 'DISPATCH'
127: AND NVL (schedule_flag, 'N') = 'Y'
128: AND task_type_id = p_task_type_id;
129: BEGIN

Line 829: , jtf_task_types_b tt

825: , ta.resource_name
826: FROM jtf_tasks_b t
827: , csf_ct_task_assignments ta
828: , jtf_task_statuses_vl ts
829: , jtf_task_types_b tt
830: WHERE t.ROWID = CHARTOROWID (p_row_id)
831: AND ts.task_status_id = t.task_status_id
832: AND tt.task_type_id = t.task_type_id
833: AND ta.task_id (+) = t.task_id;