APPS.PE_POI_BUS dependencies on PER_POSITIONS

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 106: , per_positions pos

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
109: and pbg.business_group_id = pos.business_group_id;
110: --

Line 287: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) date tracked position req.

283: l_proc varchar2(72) := g_package||'chk_position_id';
284: l_dummy varchar2(1);
285: --
286: --
287: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) date tracked position req.
288: --
289: cursor c_valid_pos (id number) is
290: select 'x'
291: from hr_all_positions_f