APPS.PER_MAINTAIN_TASKFLOW dependencies on HR_NAVIGATION_NODE_USAGES

Line 17: FROM hr_navigation_node_usages

13: -- Cursor to bring back all of the node usages for a node in a tasfklow.
14: --
15: CURSOR csr_node_usages IS
16: SELECT nav_node_usage_id
17: FROM hr_navigation_node_usages
18: WHERE workflow_id = l_workflow_id;
19: BEGIN
20: --
21: -- Find the workflow_id that corresponds to p_taskflow_name (workflow name).

Line 36: DELETE FROM hr_navigation_node_usages

32: l_nav_node_usage_id := node_usage_record.nav_node_usage_id;
33: DELETE FROM hr_navigation_paths
34: WHERE from_nav_node_usage_id = l_nav_node_usage_id
35: OR to_nav_node_usage_id = l_nav_node_usage_id;
36: DELETE FROM hr_navigation_node_usages
37: WHERE nav_node_usage_id = l_nav_node_usage_id;
38: END LOOP;
39: --
40: -- Delete the taskflow.

Line 135: FROM hr_navigation_node_usages nnu,

131: -- Bug 3648687. Modified the following cursor.
132: --
133: CURSOR csr_node_usages IS
134: SELECT nnu.nav_node_usage_id, hnp.nav_path_id
135: FROM hr_navigation_node_usages nnu,
136: hr_navigation_paths hnp
137: WHERE nav_node_id = l_nav_node_id
138: AND (nnu.nav_node_usage_id = hnp.from_nav_node_usage_id
139: OR nnu.nav_node_usage_id = hnp.to_nav_node_usage_id);

Line 164: DELETE FROM hr_navigation_node_usages

160: WHERE from_nav_node_usage_id = l_nav_node_usage_id
161: OR to_nav_node_usage_id = l_nav_node_usage_id
162: OR nav_path_id = l_nav_path_id;
163:
164: DELETE FROM hr_navigation_node_usages
165: WHERE nav_node_usage_id = l_nav_node_usage_id;
166: END LOOP;
167: --
168: -- Delete the navigation node.