APPS.PE_POI_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: -- per_position_extra_info and PER_BUSINESS_GROUPS

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

Line 36: from per_business_groups pbg

32: -- the current business group context can be derived.
33: -- Remove this comment when the edit has been completed.
34: cursor csr_sec_grp is
35: select pbg.security_group_id
36: from per_business_groups pbg
37: , per_position_extra_info poi
38: , hr_all_positions_f pos
39: where poi.position_extra_info_id = p_position_extra_info_id
40: and pbg.business_group_id = pos.business_group_id

Line 98: -- per_position_extra_info, per_positions and PER_BUSINESS_GROUPS

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

Line 104: from per_business_groups pbg

100: -- the current business group context can be derived.
101: -- Remove this comment when the edit has been completed.
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups pbg
105: , per_position_extra_info poi
106: , per_positions pos
107: where poi.position_extra_info_id = p_position_extra_info_id
108: and pos.position_id = poi.position_id