APPS.WF_FWKMON dependencies on WF_ROLES

Line 186: from wf_roles

182: colon pls_integer;
183:
184: cursor c_role is
185: select email_address
186: from wf_roles
187: where name = x_role_name
188: and ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
189: 'HZ_GROUP','CUST_CONT');
190:

Line 193: from wf_roles

189: 'HZ_GROUP','CUST_CONT');
190:
191: cursor corig_role is
192: select email_address
193: from wf_roles
194: where orig_system = substr(x_role_name, 1, colon-1)
195: and orig_system_id = substr(x_role_name, colon+1)
196: and name = x_role_name;
197:

Line 198: email wf_roles.email_address%TYPE;

194: where orig_system = substr(x_role_name, 1, colon-1)
195: and orig_system_id = substr(x_role_name, colon+1)
196: and name = x_role_name;
197:
198: email wf_roles.email_address%TYPE;
199:
200: begin
201: colon := instr(x_role_name, ':');
202: if (colon = 0) then