APPS.WF_DIRECTORY dependencies on WF_ROLE_HIERARCHIES

Line 4872: from wf_role_hierarchies where sub_name=p_name

4868: -- also call wf_role_hierarchy.removeRelaionship to delete all hierarchical
4869: -- relationships in which the role participates.
4870: begin
4871: select relationship_id bulk collect into l_relIDTab
4872: from wf_role_hierarchies where sub_name=p_name
4873: or super_name = p_name;
4874: if (l_relIDTAB.count>0) then
4875: for i in l_relIDTAB.first..l_RelIDTAB.last loop
4876: WF_ROLE_HIERARCHY.RemoveRelationship(l_relIDTab(i),TRUE);

Line 4956: or exists (select null from wf_role_hierarchies

4952: )
4953: or exists (select null from wf_user_role_assignments_v
4954: where role_name=p_rolename
4955: )
4956: or exists (select null from wf_role_hierarchies
4957: where (super_name=p_rolename
4958: or sub_name=p_rolename)
4959: and enabled_flag='Y'
4960: ));

Line 5050: or exists (select null from wf_role_hierarchies

5046: or exists (select null from wf_user_role_assignments_v
5047: where role_name=p_rolename
5048: and user_name=p_username
5049: )
5050: or exists (select null from wf_role_hierarchies
5051: where (super_name=p_rolename
5052: or sub_name=p_rolename)
5053: and enabled_flag='Y'
5054: ));