APPS.HR_WORKFLOWS_PKG dependencies on HR_NAVIGATION_PATHS_TL

Line 29: DELETE FROM hr_navigation_paths_tl

25: --
26: FOR nav_path_record IN csr_nav_paths LOOP
27: l_nav_path_id := nav_path_record.nav_path_id;
28:
29: DELETE FROM hr_navigation_paths_tl
30: WHERE nav_path_id = l_nav_path_id;
31:
32: --
33: -- Added the following code as a part of Zero Downtime Patching Project.

Line 39: p_ref_entity => 'HR_NAVIGATION_PATHS_TL',

35: --
36: BEGIN
37: per_ric_pkg.Chk_integrity (
38: p_entity_name => 'HR_NAVIGATION_PATHS',
39: p_ref_entity => 'HR_NAVIGATION_PATHS_TL',
40: p_ref_column_name => 'NAV_PATH_ID',
41: p_ref_col_value_number => l_nav_path_id,
42: p_ref_col_value_varchar => NULL,
43: p_ref_col_value_date => NULL,