APPS.PE_POI_BUS dependencies on HR_ALL_POSITIONS_F

Line 38: , hr_all_positions_f pos

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
41: and pos.position_id = poi.position_id;
42: --

Line 291: from hr_all_positions_f

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
292: where position_id = id;
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 1);

Line 886: l_position_rec hr_all_positions_f%rowtype;

882: -- ----------------------------------------------------------------------------
883: Procedure insert_validate(p_rec in pe_poi_shd.g_rec_type) is
884: --
885: l_proc varchar2(72) := g_package||'insert_validate';
886: l_position_rec hr_all_positions_f%rowtype;
887: l_position_start_date date;
888: l_effective_date date := trunc(sysdate);
889: --
890: cursor c_effective_date is

Line 897: from hr_all_positions_f

893: where session_id = userenv('sessionid');
894: --
895: cursor c_position(p_position_id number, p_effective_date date) is
896: select *
897: from hr_all_positions_f
898: where position_id = p_position_id
899: and p_effective_date between effective_start_date and effective_end_date;
900: --
901: Begin

Line 1041: l_position_rec hr_all_positions_f%rowtype;

1037: -- ----------------------------------------------------------------------------
1038: Procedure update_validate(p_rec in pe_poi_shd.g_rec_type) is
1039: --
1040: l_proc varchar2(72) := g_package||'update_validate';
1041: l_position_rec hr_all_positions_f%rowtype;
1042: l_position_start_date date;
1043: l_effective_date date := trunc(sysdate);
1044: --
1045: cursor c_effective_date is

Line 1052: from hr_all_positions_f

1048: where session_id = userenv('sessionid');
1049: --
1050: cursor c_position(p_position_id number, p_effective_date date) is
1051: select *
1052: from hr_all_positions_f
1053: where position_id = p_position_id
1054: and p_effective_date between effective_start_date and effective_end_date;
1055: --
1056: Begin

Line 1170: l_position_rec hr_all_positions_f%rowtype;

1166: -- ----------------------------------------------------------------------------
1167: Procedure delete_validate(p_rec in pe_poi_shd.g_rec_type) is
1168: --
1169: l_proc varchar2(72) := g_package||'delete_validate';
1170: l_position_rec hr_all_positions_f%rowtype;
1171: l_effective_date date := trunc(sysdate);
1172: --
1173: cursor c_effective_date is
1174: select effective_date

Line 1180: from hr_all_positions_f

1176: where session_id = userenv('sessionid');
1177: --
1178: cursor c_position(p_position_id number, p_effective_date date) is
1179: select *
1180: from hr_all_positions_f
1181: where position_id = p_position_id
1182: and p_effective_date between effective_start_date and effective_end_date;
1183: --
1184: Begin