1823: WHERE name = p_role_name;
1824:
1825: CURSOR c_get_users_from_role (p_role_name VARCHAR2) IS
1826: select user_name
1827: from wf_user_roles
1828: where role_name = p_role_name;
1829:
1830: --
1831:
2213: prll_ntf varchar2(600) := null;
2214:
2215: CURSOR c_get_users_from_role (p_role_name VARCHAR2) IS
2216: select *
2217: from wf_user_roles
2218: where role_name = p_role_name;
2219:
2220:
2221: begin
2635: l_is_parallel varchar2(10) := null;
2636:
2637: CURSOR c_get_users_from_role (p_role_name VARCHAR2) IS
2638: select *
2639: from wf_user_roles
2640: where role_name = p_role_name;
2641:
2642: begin
2643: g_debug := hr_utility.debug_enabled;
6003: prll_ntf varchar2(600) := null;
6004:
6005: CURSOR c_get_users_from_role (p_role_name VARCHAR2) IS
6006: select *
6007: from wf_user_roles
6008: where role_name = p_role_name;
6009:
6010:
6011: begin