APPS.PER_MAINTAIN_TASKFLOW dependencies on HR_NAVIGATION_NODES

Line 61: FROM hr_navigation_nodes

57: -- Cursor to bring back all of the navigation nodes for a unit.
58: --
59: CURSOR csr_nav_nodes IS
60: SELECT nav_node_id, name
61: FROM hr_navigation_nodes
62: WHERE nav_unit_id = l_nav_unit_id;
63: --
64: -- Cursor to bring back all of the global usages for a unit.
65: --

Line 146: FROM hr_navigation_nodes

142: -- Find the nav_node_id that correspond to p_nav_node_name.
143: --
144: SELECT nav_node_id
145: INTO l_nav_node_id
146: FROM hr_navigation_nodes
147: WHERE name = p_nav_node_name;
148: --
149: -- For each node usage attached to a node delete the navigation paths
150: -- then delete the node usage record.

Line 170: DELETE FROM hr_navigation_nodes

166: END LOOP;
167: --
168: -- Delete the navigation node.
169: --
170: DELETE FROM hr_navigation_nodes
171: WHERE nav_node_id = l_nav_node_id;
172: END delete_navigation_node;
173:
174: END per_maintain_taskflow;