DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on JTF_FM_SERVICE

Line 2039: , jtf_fm_service server

2035: -- Re-written cursor due to Bug 3375932
2036: SELECT server.server_name server_name
2037: FROM jtf_fm_group_fnd_user_v users
2038: , jtf_fm_group groups
2039: , jtf_fm_service server
2040: WHERE users.user_id = c_agent_id
2041: AND users.group_id = groups.group_id
2042: AND server.server_id = groups.server_id
2043: AND server.server_id = c_server_id;

Line 2048: FROM jtf_fm_service server

2044:
2045:
2046: CURSOR c_server_name_csr(c_server_id NUMBER) IS
2047: SELECT server.server_name server_name
2048: FROM jtf_fm_service server
2049: WHERE server.server_id = c_server_id;
2050:
2051: l_agent_id NUMBER;
2052: l_email VARCHAR2(1000);