APPS.GHR_POSITION_EXTRA_INFO_API dependencies on PER_POSITIONS

Line 78: l_bg_id per_positions.business_group_id%type;

74: --
75: l_proc varchar2(72) := g_package||'create_position_extra_info';
76: l_object_version_number per_position_extra_info.object_version_number%type;
77: l_position_extra_info_id per_position_extra_info.position_extra_info_id%type;
78: l_bg_id per_positions.business_group_id%type;
79: --
80:
81: cursor c_bg is
82: SELECT business_group_id

Line 83: FROM per_positions

79: --
80:
81: cursor c_bg is
82: SELECT business_group_id
83: FROM per_positions
84: WHERE position_id = p_position_id;
85:
86: begin
87: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 281: l_bg_id per_positions.business_group_id%type;

277: -- Declare cursors and local variables
278: --
279: l_proc varchar2(72) := g_package||'update_position_extra_info';
280: l_object_version_number per_position_extra_info.object_version_number%TYPE;
281: l_bg_id per_positions.business_group_id%type;
282: --
283:
284: cursor c_bg is
285: SELECT pos.business_group_id

Line 286: FROM per_positions pos, per_position_extra_info poi

282: --
283:
284: cursor c_bg is
285: SELECT pos.business_group_id
286: FROM per_positions pos, per_position_extra_info poi
287: WHERE pos.position_id = poi.position_id
288: AND poi.position_extra_info_id = p_position_extra_info_id;
289:
290: --