APPS.PER_TASKFLOW_MIGRATION dependencies on HR_NAVIGATION_UNITS

Line 34: delete from HR_NAVIGATION_UNITS_TL T

30: begin
31: /*
32: ** clear out any existing data for this range of records
33: */
34: delete from HR_NAVIGATION_UNITS_TL T
35: where not exists
36: (select NULL
37: from HR_NAVIGATION_UNITS B
38: where B.NAV_UNIT_ID = T.NAV_UNIT_ID

Line 37: from HR_NAVIGATION_UNITS B

33: */
34: delete from HR_NAVIGATION_UNITS_TL T
35: where not exists
36: (select NULL
37: from HR_NAVIGATION_UNITS B
38: where B.NAV_UNIT_ID = T.NAV_UNIT_ID
39: );
40: /*
41: **

Line 58: insert into hr_navigation_units_tl (

54: /*
55: ** insert the TL rows
56: */
57:
58: insert into hr_navigation_units_tl (
59: nav_unit_id
60: ,language
61: ,source_lang
62: ,default_label

Line 76: from hr_navigation_units b

72: ,1
73: ,sysdate
74: ,1
75: ,sysdate
76: from hr_navigation_units b
77: where not exists
78: (select '1'
79: from hr_navigation_units_tl t
80: where t.nav_unit_id = b.nav_unit_id

Line 79: from hr_navigation_units_tl t

75: ,sysdate
76: from hr_navigation_units b
77: where not exists
78: (select '1'
79: from hr_navigation_units_tl t
80: where t.nav_unit_id = b.nav_unit_id
81: and t.language = l_current_language);
82:
83: end loop;