APPS.WF_NOTIFICATION dependencies on WF_ROLES

Line 1596: from WF_ROLES WR

1592: colon := instr(not_attr_row.text_value, ':');
1593: if (colon = 0) then
1594: select WR.DISPLAY_NAME
1595: into value
1596: from WF_ROLES WR
1597: where WR.NAME = not_attr_row.text_value
1598: and WR.ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
1599: 'HZ_GROUP','CUST_CONT');
1600: else

Line 1603: from WF_ROLES WR

1599: 'HZ_GROUP','CUST_CONT');
1600: else
1601: select WR.DISPLAY_NAME
1602: into value
1603: from WF_ROLES WR
1604: where WR.ORIG_SYSTEM = substr(not_attr_row.text_value, 1, colon-1)
1605: and WR.ORIG_SYSTEM_ID = substr(not_attr_row.text_value, colon+1)
1606: and WR.NAME = not_attr_row.text_value;
1607: end if;

Line 9247: -- Get recipient information using Dir Service API. Select from WF_ROLES

9243: wf_core.token('NID', to_char(p_nid));
9244: wf_core.raise('WFNTF_NID');
9245: end;
9246:
9247: -- Get recipient information using Dir Service API. Select from WF_ROLES
9248: -- may not give the right information
9249: Wf_Directory.GetRoleInfoMail(l_recipient_role, l_display_name, l_email_address,
9250: l_notification_pref, l_language, l_territory,
9251: l_orig_system, l_orig_system_id, l_installed);