APPS.EDR_UTILITIES dependencies on WF_ROLES

Line 2395: select count(*) into l_count from wf_roles

2391: l_pos := instr(l_approving_users,',');
2392: if(l_pos = 0) then
2393:
2394: --Check if the specified user name is an FND USER.
2395: select count(*) into l_count from wf_roles
2396: where name = l_approving_users
2397: and status = 'ACTIVE'
2398: and (orig_system = 'PER' or ORIG_SYSTEM = 'FND_USR');
2399:

Line 2405: select count(*) into l_count from wf_roles

2401: --If count is zero then, then check if the specified user name is a responsibility.
2402: if(l_count = 0) then
2403:
2404: --Check if the specified user name is a responsibility
2405: select count(*) into l_count from wf_roles
2406: where name = l_approving_users
2407: and status = 'ACTIVE'
2408: and orig_system = 'FND_RESP';
2409:

Line 2436: select count(*) into l_count from wf_roles

2432: --Filter the source string to remove the approvers extracted in the previous step.
2433: l_approving_users := substr(l_approving_users,l_pos+1,length(l_approving_users)-length(l_current_approving_user) + 1);
2434:
2435: --Check if the specified user name is an fnd user.
2436: select count(*) into l_count from wf_roles
2437: where name = l_current_approving_user
2438: and status = 'ACTIVE'
2439: and (orig_system = 'PER' or orig_system = 'FND_USR');
2440:

Line 2445: select count(*) into l_count from wf_roles

2441: --If count is zero then, then check if the specified user name is a responsibility.
2442: if(l_count = 0) then
2443:
2444: --Check if the specified user name is a responsibility
2445: select count(*) into l_count from wf_roles
2446: where name = l_current_approving_user
2447: and status = 'ACTIVE'
2448: and orig_system = 'FND_RESP';
2449: