APPS.OKL_KBK_APPROVALS_WF dependencies on WF_USERS

Line 85: CURSOR wf_users_csr(c_user_id NUMBER)

81: x_return_status OUT NOCOPY VARCHAR2,
82: x_name OUT NOCOPY VARCHAR2,
83: x_description OUT NOCOPY VARCHAR2) IS
84:
85: CURSOR wf_users_csr(c_user_id NUMBER)
86: IS
87: SELECT NAME, DISPLAY_NAME
88: FROM WF_USERS
89: WHERE orig_system_id = c_user_id

Line 88: FROM WF_USERS

84:
85: CURSOR wf_users_csr(c_user_id NUMBER)
86: IS
87: SELECT NAME, DISPLAY_NAME
88: FROM WF_USERS
89: WHERE orig_system_id = c_user_id
90: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
91:
92: CURSOR fnd_users_csr(c_user_id NUMBER)

Line 99: OPEN wf_users_csr(p_user_id);

95: FROM FND_USER
96: WHERE user_id = c_user_id;
97: BEGIN
98: x_return_status := OKL_API.G_RET_STS_SUCCESS;
99: OPEN wf_users_csr(p_user_id);
100: FETCH wf_users_csr INTO x_name, x_description;
101: CLOSE wf_users_csr;
102: IF x_name IS NULL THEN
103: OPEN fnd_users_csr(p_user_id);

Line 100: FETCH wf_users_csr INTO x_name, x_description;

96: WHERE user_id = c_user_id;
97: BEGIN
98: x_return_status := OKL_API.G_RET_STS_SUCCESS;
99: OPEN wf_users_csr(p_user_id);
100: FETCH wf_users_csr INTO x_name, x_description;
101: CLOSE wf_users_csr;
102: IF x_name IS NULL THEN
103: OPEN fnd_users_csr(p_user_id);
104: FETCH fnd_users_csr INTO x_name, x_description;

Line 101: CLOSE wf_users_csr;

97: BEGIN
98: x_return_status := OKL_API.G_RET_STS_SUCCESS;
99: OPEN wf_users_csr(p_user_id);
100: FETCH wf_users_csr INTO x_name, x_description;
101: CLOSE wf_users_csr;
102: IF x_name IS NULL THEN
103: OPEN fnd_users_csr(p_user_id);
104: FETCH fnd_users_csr INTO x_name, x_description;
105: CLOSE fnd_users_csr;