APPS.HR_ORT_BUS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 28: -- hr_all_organization_units_tl and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hr_all_organization_units_tl and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 97: -- hr_all_organization_units_tl and PER_BUSINESS_GROUPS

93: --
94: -- Declare cursor
95: --
96: -- EDIT_HERE In the following cursor statement add join(s) between
97: -- hr_all_organization_units_tl and PER_BUSINESS_GROUPS
98: -- so that the legislation_code for
99: -- the current business group context can be derived.
100: -- Remove this comment when the edit has been completed.
101: cursor csr_leg_code is

Line 104: , hr_all_organization_units_tl ort

100: -- Remove this comment when the edit has been completed.
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups pbg
104: , hr_all_organization_units_tl ort
105: -- , EDIT_HERE table_name(s) 333
106: where ort.organization_id = p_organization_id
107: and ort.language = p_language;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;