DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on JTF_FM_GROUP

Line 2037: FROM jtf_fm_group_fnd_user_v users

2033:
2034: CURSOR c_server_csr(c_agent_id NUMBER, c_server_id NUMBER) IS
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

Line 2038: , jtf_fm_group groups

2034: CURSOR c_server_csr(c_agent_id NUMBER, c_server_id NUMBER) IS
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