DBA Data[Home] [Help]

APPS.HR_APPROVAL_SS dependencies on WF_USER_ROLES

Line 1827: from wf_user_roles

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:

Line 2217: from wf_user_roles

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

Line 2639: from wf_user_roles

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;

Line 6007: from wf_user_roles

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