APPS.OKL_SUBSIDY_POOL_WF dependencies on WF_USERS

Line 61: CURSOR wf_users_csr(cp_user_id NUMBER)IS

57: x_return_status OUT NOCOPY VARCHAR2,
58: x_name OUT NOCOPY VARCHAR2,
59: x_description OUT NOCOPY VARCHAR2) IS
60:
61: CURSOR wf_users_csr(cp_user_id NUMBER)IS
62: SELECT NAME, DISPLAY_NAME
63: FROM WF_USERS
64: WHERE orig_system_id = p_user_id
65: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;

Line 63: FROM WF_USERS

59: x_description OUT NOCOPY VARCHAR2) IS
60:
61: CURSOR wf_users_csr(cp_user_id NUMBER)IS
62: SELECT NAME, DISPLAY_NAME
63: FROM WF_USERS
64: WHERE orig_system_id = p_user_id
65: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
66:
67: CURSOR fnd_users_csr(c_user_id NUMBER)

Line 74: OPEN wf_users_csr(p_user_id);

70: FROM FND_USER
71: WHERE user_id = c_user_id;
72: BEGIN
73: x_return_status := OKL_API.G_RET_STS_SUCCESS;
74: OPEN wf_users_csr(p_user_id);
75: FETCH wf_users_csr INTO x_name, x_description;
76: CLOSE wf_users_csr;
77: IF x_name IS NULL THEN
78: OPEN fnd_users_csr(p_user_id);

Line 75: FETCH wf_users_csr INTO x_name, x_description;

71: WHERE user_id = c_user_id;
72: BEGIN
73: x_return_status := OKL_API.G_RET_STS_SUCCESS;
74: OPEN wf_users_csr(p_user_id);
75: FETCH wf_users_csr INTO x_name, x_description;
76: CLOSE wf_users_csr;
77: IF x_name IS NULL THEN
78: OPEN fnd_users_csr(p_user_id);
79: FETCH fnd_users_csr INTO x_name, x_description;

Line 76: CLOSE wf_users_csr;

72: BEGIN
73: x_return_status := OKL_API.G_RET_STS_SUCCESS;
74: OPEN wf_users_csr(p_user_id);
75: FETCH wf_users_csr INTO x_name, x_description;
76: CLOSE wf_users_csr;
77: IF x_name IS NULL THEN
78: OPEN fnd_users_csr(p_user_id);
79: FETCH fnd_users_csr INTO x_name, x_description;
80: CLOSE fnd_users_csr;