DBA Data[Home] [Help]

APPS.JTF_TASK_WF_UTIL dependencies on WF_LOCAL_ROLES

Line 233: 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

229: WHERE resource_id IN(SELECT team_resource_id
230: FROM jtf_rs_team_members
231: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
232:
233: 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
234: SELECT name
235: FROM wf_local_roles
236: WHERE orig_system = b_orig_system
237: AND orig_system_id = b_orig_system_id

Line 235: FROM wf_local_roles

231: WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
232:
233: 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
234: SELECT name
235: FROM wf_local_roles
236: WHERE orig_system = b_orig_system
237: AND orig_system_id = b_orig_system_id
238: AND user_flag='N';
239: