DBA Data[Home] [Help]

APPS.JTF_TASK_WF_UTIL dependencies on WF_LOCAL_ROLES

Line 200: CURSOR c_group_team_role(b_orig_system wf_local_roles.orig_system%TYPE, b_orig_system_id wf_local_roles.orig_system_id%TYPE) IS

196: WHERE resource_id IN(SELECT team_resource_id
197: FROM jtf_rs_team_members
198: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
199:
200: CURSOR c_group_team_role(b_orig_system wf_local_roles.orig_system%TYPE, b_orig_system_id wf_local_roles.orig_system_id%TYPE) IS
201: SELECT name
202: FROM wf_local_roles
203: WHERE orig_system = b_orig_system
204: AND orig_system_id = b_orig_system_id

Line 202: FROM wf_local_roles

198: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
199:
200: CURSOR c_group_team_role(b_orig_system wf_local_roles.orig_system%TYPE, b_orig_system_id wf_local_roles.orig_system_id%TYPE) IS
201: SELECT name
202: FROM wf_local_roles
203: WHERE orig_system = b_orig_system
204: AND orig_system_id = b_orig_system_id
205: AND user_flag='N';
206: