DBA Data[Home] [Help]

APPS.WF_DIRECTORY_PART_UTIL dependencies on WF_ROLES

Line 118: from WF_ROLES

114:
115: if (l_colon = 0) then
116: select count(1)
117: into l_names_count
118: from WF_ROLES
119: where NAME = p_user_name
120: and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
121: 'HZ_GROUP','CUST_CONT')
122: and DISPLAY_NAME = p_display_name;

Line 138: from WF_ROLES

134: raise;
135: end;
136: select count(1)
137: into l_names_count
138: from WF_ROLES
139: where NAME = p_user_name
140: and ORIG_SYSTEM = substr(p_user_name, 1, l_colon-1)
141: and ORIG_SYSTEM_ID = l_orig_system_id
142: and DISPLAY_NAME = p_display_name;