APPS.IEX_WF_NEW_DEL_STATUS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 44: FROM JTF_RS_RESOURCE_EXTNS a

40: l_manager_name varchar2(30);
41:
42: CURSOR c_get_manager(p_user_id NUMBER) IS
43: SELECT b.user_id, b.user_name
44: FROM JTF_RS_RESOURCE_EXTNS a
45: ,JTF_RS_RESOURCE_EXTNS b
46: WHERE b.source_id = a.source_mgr_id
47: AND a.user_id = p_user_id;
48:

Line 45: ,JTF_RS_RESOURCE_EXTNS b

41:
42: CURSOR c_get_manager(p_user_id NUMBER) IS
43: SELECT b.user_id, b.user_name
44: FROM JTF_RS_RESOURCE_EXTNS a
45: ,JTF_RS_RESOURCE_EXTNS b
46: WHERE b.source_id = a.source_mgr_id
47: AND a.user_id = p_user_id;
48:
49: BEGIN

Line 220: FROM JTF_RS_RESOURCE_EXTNS a

216: l_manager_name varchar2(30);
217:
218: CURSOR c_get_manager(p_user_id NUMBER) IS
219: SELECT b.user_id, b.user_name
220: FROM JTF_RS_RESOURCE_EXTNS a
221: ,JTF_RS_RESOURCE_EXTNS b
222: WHERE b.source_id = a.source_mgr_id
223: AND a.user_id = p_user_id;
224:

Line 221: ,JTF_RS_RESOURCE_EXTNS b

217:
218: CURSOR c_get_manager(p_user_id NUMBER) IS
219: SELECT b.user_id, b.user_name
220: FROM JTF_RS_RESOURCE_EXTNS a
221: ,JTF_RS_RESOURCE_EXTNS b
222: WHERE b.source_id = a.source_mgr_id
223: AND a.user_id = p_user_id;
224:
225: BEGIN