APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 52: FROM JTF_RS_RESOURCE_EXTNS a

48: l_account_number varchar2(30) := '';
49:
50: CURSOR c_manager(p_user_id NUMBER) IS
51: SELECT b.user_id, b.user_name
52: FROM JTF_RS_RESOURCE_EXTNS a
53: , JTF_RS_RESOURCE_EXTNS b
54: WHERE b.source_id = a.source_mgr_id
55: AND a.user_id = p_user_id;
56:

Line 53: , JTF_RS_RESOURCE_EXTNS b

49:
50: CURSOR c_manager(p_user_id NUMBER) IS
51: SELECT b.user_id, b.user_name
52: FROM JTF_RS_RESOURCE_EXTNS a
53: , JTF_RS_RESOURCE_EXTNS b
54: WHERE b.source_id = a.source_mgr_id
55: AND a.user_id = p_user_id;
56:
57: BEGIN

Line 344: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS

340: -- result := 'COMPLETE';
341: END IF;
342: --DBMS_OUTPUT.PUT_LINE('*');
343: -- Get manager
344: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
345: WHERE user_id = p_user_id;
346:
347: OPEN C_MANAGER(p_user_id);
348: FETCH C_MANAGER INTO l_manager_id, l_manager_name;