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