APPS.OKL_CREDIT_LINE_WF dependencies on WF_USERS

Line 95: CURSOR wf_users_csr(c_user_id NUMBER)

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

Line 98: FROM WF_USERS

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

Line 109: OPEN wf_users_csr(p_user_id);

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

Line 110: FETCH wf_users_csr INTO x_name, x_description;

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

Line 111: CLOSE wf_users_csr;

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