APPS.WF_DIRECTORY dependencies on WF_ROLE_HIERARCHIES

Line 5009: from wf_role_hierarchies where sub_name=p_name

5005: -- also call wf_role_hierarchy.removeRelaionship to delete all hierarchical
5006: -- relationships in which the role participates.
5007: begin
5008: select relationship_id bulk collect into l_relIDTab
5009: from wf_role_hierarchies where sub_name=p_name
5010: or super_name = p_name;
5011: if (l_relIDTAB.count>0) then
5012: for i in l_relIDTAB.first..l_RelIDTAB.last loop
5013: WF_ROLE_HIERARCHY.RemoveRelationship(l_relIDTab(i),TRUE);

Line 5093: or exists (select null from wf_role_hierarchies

5089: )
5090: or exists (select null from wf_user_role_assignments_v
5091: where role_name=p_rolename
5092: )
5093: or exists (select null from wf_role_hierarchies
5094: where (super_name=p_rolename
5095: or sub_name=p_rolename)
5096: and enabled_flag='Y'
5097: ));

Line 5187: or exists (select null from wf_role_hierarchies

5183: or exists (select null from wf_user_role_assignments_v
5184: where role_name=p_rolename
5185: and user_name=p_username
5186: )
5187: or exists (select null from wf_role_hierarchies
5188: where (super_name=p_rolename
5189: or sub_name=p_rolename)
5190: and enabled_flag='Y'
5191: ));