APPS.PER_MAINTAIN_TASKFLOW dependencies on HR_NAVIGATION_PATHS

Line 33: DELETE FROM hr_navigation_paths

29: -- then delete the node usage record.
30: --
31: FOR node_usage_record IN csr_node_usages LOOP
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;

Line 136: hr_navigation_paths hnp

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);
140: BEGIN

Line 156: DELETE FROM hr_navigation_paths_tl

152: FOR node_usage_record IN csr_node_usages LOOP
153: l_nav_node_usage_id := node_usage_record.nav_node_usage_id;
154: l_nav_path_id := node_usage_record.nav_path_id;
155:
156: DELETE FROM hr_navigation_paths_tl
157: WHERE nav_path_id = l_nav_path_id;
158:
159: DELETE FROM hr_navigation_paths
160: WHERE from_nav_node_usage_id = l_nav_node_usage_id

Line 159: DELETE FROM hr_navigation_paths

155:
156: DELETE FROM hr_navigation_paths_tl
157: WHERE nav_path_id = l_nav_path_id;
158:
159: DELETE FROM hr_navigation_paths
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: