DBA Data[Home] [Help]

APPS.UMX_W3H_UTL dependencies on WF_ROLE_HIERARCHIES

Line 147: select super_name roleName from wf_role_hierarchies

143: from fnd_responsibility fr,fnd_resp_functions frf, wf_local_roles wur,fnd_form_functions frm,
144: (select wur1.name roleName from wf_local_roles wur1
145: where wur1.name = p_resp_name
146: union
147: select super_name roleName from wf_role_hierarchies
148: where enabled_flag='Y'
149: connect by prior super_name=sub_name
150: and prior enabled_flag='Y'
151: start with sub_name= p_resp_name) roles