APPS.OTA_THG_BUS dependencies on OTA_HR_GL_FLEX_MAPS

Line 27: -- ota_hr_gl_flex_maps and PER_BUSINESS_GROUPS

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

Line 34: , ota_hr_gl_flex_maps thg

30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups_perf pbg
34: , ota_hr_gl_flex_maps thg
35: , ota_cross_charges tcc
36: where tcc.cross_charge_id = thg.cross_charge_id and
37: thg.gl_default_segment_id = p_gl_default_segment_id and
38: pbg.business_group_id = tcc.business_group_id;

Line 94: -- ota_hr_gl_flex_maps and PER_BUSINESS_GROUPS

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

Line 101: , ota_hr_gl_flex_maps thg

97: -- Remove this comment when the edit has been completed.
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_hr_gl_flex_maps thg
102: , ota_cross_charges tcc
103: where tcc. Cross_charge_id = thg.cross_charge_id and
104: thg.gl_default_segment_id = p_gl_default_segment_id and
105: pbg.business_group_id = tcc.business_group_id;