APPS.WF_MONITOR dependencies on WF_ROLES

Line 1184: from wf_roles r

1180: tmpbuf3 varchar2, tmpbuf4 varchar2) is
1181:
1182: select r.name,
1183: r.display_name
1184: from wf_roles r
1185: where display_name not like '~WF_ADHOC-%'
1186: and (display_name like tmpbuf1 or
1187: display_name like tmpbuf2 or
1188: display_name like tmpbuf3 or

Line 1215: from wf_roles

1211: tmpbuf2 := upper(first_char)||lower(second_char)||'%';
1212: tmpbuf3 := lower(first_char)||upper(second_char)||'%';
1213: tmpbuf4 := lower(first_char)||lower(second_char)||'%';
1214: select count(*) into cnt
1215: from wf_roles
1216: where display_name not like '~WF_ADHOC-%'
1217: and (display_name like tmpbuf1 or
1218: display_name like tmpbuf2 or
1219: display_name like tmpbuf3 or

Line 1252: from wf_roles r

1248:
1249: cursor role is
1250: select r.name,
1251: r.display_name
1252: from wf_roles r
1253: order by r.display_name;
1254:
1255:
1256: username varchar2(320);

Line 3671: ** be used on wf_roles to preserve indexes over the view.

3667:
3668: /*
3669: ** Retrieve role information. This has to be selected separately
3670: ** instead of joining into main select so the orig_system_ids can
3671: ** be used on wf_roles to preserve indexes over the view.
3672: */
3673: if (x_activity_record.recipient_role is not null) then
3674: wf_directory.getroleinfo(x_activity_record.recipient_role,
3675: role_name, email_address, buf, buf, buf);