APPS.OKL_SEC_AGREEMENT_WF dependencies on WF_USERS

Line 99: CURSOR wf_users_csr(c_user_id NUMBER)

95: x_return_status OUT NOCOPY VARCHAR2,
96: x_name OUT NOCOPY VARCHAR2,
97: x_description OUT NOCOPY VARCHAR2) IS
98:
99: CURSOR wf_users_csr(c_user_id NUMBER)
100: IS
101: SELECT NAME, DISPLAY_NAME
102: FROM WF_USERS
103: WHERE orig_system_id = c_user_id

Line 102: FROM WF_USERS

98:
99: CURSOR wf_users_csr(c_user_id NUMBER)
100: IS
101: SELECT NAME, DISPLAY_NAME
102: FROM WF_USERS
103: WHERE orig_system_id = c_user_id
104: AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
105:
106: CURSOR fnd_users_csr(c_user_id NUMBER)

Line 113: OPEN wf_users_csr(p_user_id);

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

Line 114: FETCH wf_users_csr INTO x_name, x_description;

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

Line 115: CLOSE wf_users_csr;

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