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 wfu.NAME, wfu.DISPLAY_NAME
97: FROM WF_USERS wfu, fnd_user fndu
98: WHERE wfu.orig_system_id = fndu.employee_id

Line 97: FROM WF_USERS wfu, fnd_user fndu

93:
94: CURSOR wf_users_csr(c_user_id NUMBER)
95: IS
96: SELECT wfu.NAME, wfu.DISPLAY_NAME
97: FROM WF_USERS wfu, fnd_user fndu
98: WHERE wfu.orig_system_id = fndu.employee_id
99: AND fndu.employee_id = c_user_id
100: AND wfu.ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
101: -- Bug#10098094: Modified by RGOOTY

Line 111: OPEN wf_users_csr(p_user_id);

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

Line 112: FETCH wf_users_csr INTO x_name, x_description;

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

Line 113: CLOSE wf_users_csr;

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