APPS.HR_WORKFLOW_INSTALL_PKG dependencies on HR_NAVIGATION_PATHS_TL

Line 67: hr_navigation_paths_tl PTL

63: hr_navigation_nodes NN,
64: hr_navigation_units NU2,
65: hr_navigation_nodes NN2,
66: hr_navigation_paths P,
67: hr_navigation_paths_tl PTL
68: WHERE nn2.nav_node_id = nnu2.nav_node_id
69: AND nnu2.workflow_id = w.workflow_id
70: AND nn2.nav_unit_id = nu2.nav_unit_id
71: AND p.FROM_NAV_NODE_USAGE_ID = nnu2.nav_node_usage_id

Line 530: from HR_NAVIGATION_PATHS_TL T

526: from FND_LANGUAGES L
527: where L.INSTALLED_FLAG in ('I', 'B')
528: and not exists
529: (select NULL
530: from HR_NAVIGATION_PATHS_TL T
531: where T.NAV_PATH_ID = L_NAV_PATH_ID
532: and T.LANGUAGE = L.LANGUAGE_CODE);
533:
534: insert into hr_navigation_paths_tl (

Line 534: insert into hr_navigation_paths_tl (

530: from HR_NAVIGATION_PATHS_TL T
531: where T.NAV_PATH_ID = L_NAV_PATH_ID
532: and T.LANGUAGE = L.LANGUAGE_CODE);
533:
534: insert into hr_navigation_paths_tl (
535: nav_path_id
536: ,language
537: ,source_lang
538: ,override_label

Line 547: from hr_navigation_paths_tl t

543: ,b.override_label
544: from hr_navigation_paths b
545: where not exists
546: (select '1'
547: from hr_navigation_paths_tl t
548: where t.nav_path_id = b.nav_path_id
549: and t.language = l_current_language);
550:
551: end new_path;