DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on FND_USER

Line 2028: FROM fnd_user fu,

2024: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2025:
2026: CURSOR c_agent_csr (c_agent_id NUMBER) IS
2027: SELECT nvl(ppf.email_address , fu.email_address) email
2028: FROM fnd_user fu,
2029: per_people_f ppf
2030: WHERE fu.employee_id = ppf.person_id (+)
2031: AND fu.user_id = c_agent_id;
2032:

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