APPS.OKL_FUNDING_WF dependencies on WF_USERS

Line 94: CURSOR wf_users_csr(c_user_id NUMBER)

90: x_return_status OUT NOCOPY VARCHAR2,
91: x_name OUT NOCOPY VARCHAR2,
92: x_description OUT NOCOPY VARCHAR2) IS
93:
94: CURSOR wf_users_csr(c_user_id NUMBER)
95: IS
96: SELECT NAME, DISPLAY_NAME
97: FROM WF_USERS
98: WHERE orig_system_id = c_user_id

Line 97: FROM WF_USERS

93:
94: CURSOR wf_users_csr(c_user_id NUMBER)
95: IS
96: SELECT NAME, DISPLAY_NAME
97: FROM WF_USERS
98: WHERE orig_system_id = c_user_id
99: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
100:
101: CURSOR fnd_users_csr(c_user_id NUMBER)

Line 108: OPEN wf_users_csr(p_user_id);

104: FROM FND_USER
105: WHERE user_id = c_user_id;
106: BEGIN
107: x_return_status := OKL_API.G_RET_STS_SUCCESS;
108: OPEN wf_users_csr(p_user_id);
109: FETCH wf_users_csr INTO x_name, x_description;
110: CLOSE wf_users_csr;
111: IF x_name IS NULL THEN
112: OPEN fnd_users_csr(p_user_id);

Line 109: FETCH wf_users_csr INTO x_name, x_description;

105: WHERE user_id = c_user_id;
106: BEGIN
107: x_return_status := OKL_API.G_RET_STS_SUCCESS;
108: OPEN wf_users_csr(p_user_id);
109: FETCH wf_users_csr INTO x_name, x_description;
110: CLOSE wf_users_csr;
111: IF x_name IS NULL THEN
112: OPEN fnd_users_csr(p_user_id);
113: FETCH fnd_users_csr INTO x_name, x_description;

Line 110: CLOSE wf_users_csr;

106: BEGIN
107: x_return_status := OKL_API.G_RET_STS_SUCCESS;
108: OPEN wf_users_csr(p_user_id);
109: FETCH wf_users_csr INTO x_name, x_description;
110: CLOSE wf_users_csr;
111: IF x_name IS NULL THEN
112: OPEN fnd_users_csr(p_user_id);
113: FETCH fnd_users_csr INTO x_name, x_description;
114: CLOSE fnd_users_csr;