APPS.IEX_WF_BAN_STATUS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 47: FROM JTF_RS_RESOURCE_EXTNS a

43: l_api_version_number NUMBER;
44:
45: CURSOR c_manager(p_user_id NUMBER) IS
46: SELECT b.user_id, b.user_name
47: FROM JTF_RS_RESOURCE_EXTNS a
48: , JTF_RS_RESOURCE_EXTNS b
49: WHERE b.source_id = a.source_mgr_id
50: AND a.user_id = p_user_id;
51:

Line 48: , JTF_RS_RESOURCE_EXTNS b

44:
45: CURSOR c_manager(p_user_id NUMBER) IS
46: SELECT b.user_id, b.user_name
47: FROM JTF_RS_RESOURCE_EXTNS a
48: , JTF_RS_RESOURCE_EXTNS b
49: WHERE b.source_id = a.source_mgr_id
50: AND a.user_id = p_user_id;
51:
52: BEGIN

Line 105: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS

101: end if;
102:
103: begin
104: -- Get manager
105: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
106: WHERE user_id = p_user_id;
107: exception
108: when others then
109: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow usernme exception');