APPS.IEX_WF_BAN_STATUS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 262: FROM JTF_RS_RESOURCE_EXTNS a

258: l_account_number varchar2(30) := '';
259:
260: CURSOR c_manager(p_user_id NUMBER) IS
261: SELECT b.user_id, b.user_name
262: FROM JTF_RS_RESOURCE_EXTNS a
263: , JTF_RS_RESOURCE_EXTNS b
264: WHERE b.source_id = a.source_mgr_id
265: AND a.user_id = p_user_id;
266:

Line 263: , JTF_RS_RESOURCE_EXTNS b

259:
260: CURSOR c_manager(p_user_id NUMBER) IS
261: SELECT b.user_id, b.user_name
262: FROM JTF_RS_RESOURCE_EXTNS a
263: , JTF_RS_RESOURCE_EXTNS b
264: WHERE b.source_id = a.source_mgr_id
265: AND a.user_id = p_user_id;
266:
267: BEGIN

Line 320: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS

316: end if;
317:
318: begin
319: -- Get manager
320: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
321: WHERE user_id = p_user_id;
322: exception
323: when others then
324: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow usernme exception');