APPS.JTF_RS_RESOURCE_PUB dependencies on JTF_OBJECT_USAGES

Line 26: where object_code in ( select object_code from jtf_object_usages

22: Function get_wf_role ( resource_id in number )
23: RETURN varchar2 IS
24:
25: cursor c1 is select select_id , from_table , where_clause from jtf_objects_vl
26: where object_code in ( select object_code from jtf_object_usages
27: where object_user_code = 'RESOURCE_WORKFLOW' ) ;
28:
29: --Adding this cursor to display the resource name in the message (repuri 03/12/01)
30: cursor c_rs_name (l_resource_id IN NUMBER) IS