APPS.HR_WORKFLOWS_PKG dependencies on HR_NAVIGATION_PATHS

Line 16: FROM hr_navigation_paths

12: WHERE workflow_id = x_workflow_id;
13:
14: CURSOR csr_nav_paths is
15: SELECT nav_path_id
16: FROM hr_navigation_paths
17: WHERE from_nav_node_usage_id = l_nav_node_usage_id
18: OR to_nav_node_usage_id = l_nav_node_usage_id;
19: begin
20: --

Line 30: DELETE FROM hr_navigation_paths_tl

26: --
27: FOR nav_path_record IN csr_nav_paths LOOP
28: l_nav_path_id := nav_path_record.nav_path_id;
29:
30: DELETE FROM hr_navigation_paths_tl
31: WHERE nav_path_id = l_nav_path_id;
32:
33: DELETE FROM hr_navigation_paths
34: WHERE from_nav_node_usage_id = l_nav_node_usage_id

Line 33: DELETE FROM hr_navigation_paths

29:
30: DELETE FROM hr_navigation_paths_tl
31: WHERE nav_path_id = l_nav_path_id;
32:
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: --
37: END LOOP;