APPS.BEN_PERSON_OBJECT dependencies on PER_PERIODS_OF_SERVICE

Line 578: procedure set_object(p_rec in out NOCOPY per_periods_of_service%rowtype) is

574: -- hr_utility.set_location('Leaving '||l_proc,10);
575: --
576: end set_object;
577: --
578: procedure set_object(p_rec in out NOCOPY per_periods_of_service%rowtype) is
579: --
580: l_proc varchar2(80) := g_package||'set_object pds';
581: l_index pls_integer;
582: --

Line 1937: p_rec in out nocopy per_periods_of_service%rowtype) is

1933: procedure set_pps_object
1934: (p_person_id in number,
1935: p_business_group_id in number,
1936: p_effective_date in date,
1937: p_rec in out nocopy per_periods_of_service%rowtype) is
1938: --
1939: l_proc varchar2(80) := g_package||'set_pps_object';
1940: l_index pls_integer;
1941: --

Line 1944: from per_periods_of_service pps

1940: l_index pls_integer;
1941: --
1942: cursor c1 is
1943: select pps.*
1944: from per_periods_of_service pps
1945: where pps.person_id = p_person_id
1946: and pps.business_group_id = p_business_group_id
1947: and p_effective_date >= pps.date_start
1948: order by pps.date_start desc;

Line 1950: --l_rec per_periods_of_service%rowtype;

1946: and pps.business_group_id = p_business_group_id
1947: and p_effective_date >= pps.date_start
1948: order by pps.date_start desc;
1949: --
1950: --l_rec per_periods_of_service%rowtype;
1951: --115.23 - comment out unneeded record
1952: --
1953: begin
1954: --

Line 2954: p_rec in out nocopy per_periods_of_service%rowtype) is

2950: --
2951: end get_object;
2952: --
2953: procedure get_object(p_person_id in number,
2954: p_rec in out nocopy per_periods_of_service%rowtype) is
2955: --
2956: l_proc varchar2(80) := g_package||'get_object pds';
2957: l_index pls_integer;
2958: --l_not_hash_found boolean;

Line 2960: --l_rec per_periods_of_service%rowtype;

2956: l_proc varchar2(80) := g_package||'get_object pds';
2957: l_index pls_integer;
2958: --l_not_hash_found boolean;
2959: l_env ben_env_object.g_global_env_rec_type;
2960: --l_rec per_periods_of_service%rowtype;
2961: -- FONM
2962: l_effective_date date;
2963: --
2964: --

Line 3802: l_cache_last_pps_rec per_periods_of_service%rowtype;

3798: l_cache_last_per_rec per_all_people_f%rowtype;
3799: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3800: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3801: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3802: l_cache_last_pps_rec per_periods_of_service%rowtype;
3803: l_cache_last_pad_rec per_addresses%rowtype;
3804: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3805: l_cache_last_date_rec g_person_date_info_rec;
3806: l_cache_last_fte_rec g_person_fte_info_rec;

Line 3865: l_cache_last_pps_rec per_periods_of_service%rowtype;

3861: l_cache_last_per_rec per_all_people_f%rowtype;
3862: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3863: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3864: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3865: l_cache_last_pps_rec per_periods_of_service%rowtype;
3866: l_cache_last_pad_rec per_addresses%rowtype;
3867: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3868: l_cache_last_date_rec g_person_date_info_rec;
3869: l_cache_last_fte_rec g_person_fte_info_rec;