APPS.HR_WORKFLOWS_PKG dependencies on HR_NAVIGATION_NODE_USAGES

Line 11: FROM hr_navigation_node_usages

7: l_nav_node_usage_id NUMBER;
8: l_nav_path_id number;
9: CURSOR csr_node_usages IS
10: SELECT nav_node_usage_id
11: FROM hr_navigation_node_usages
12: WHERE workflow_id = x_workflow_id;
13:
14: CURSOR csr_nav_paths is
15: SELECT nav_path_id

Line 39: DELETE FROM hr_navigation_node_usages

35: OR to_nav_node_usage_id = l_nav_node_usage_id;
36: --
37: END LOOP;
38: --
39: DELETE FROM hr_navigation_node_usages
40: WHERE nav_node_usage_id = l_nav_node_usage_id;
41: --
42: END LOOP;
43: end CLEANUP_TASKFLOW_UPDATE;