APPS.BEN_PERSON_OBJECT dependencies on PER_PERIODS_OF_SERVICE

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

552: -- hr_utility.set_location('Leaving '||l_proc,10);
553: --
554: end set_object;
555: --
556: procedure set_object(p_rec in out NOCOPY per_periods_of_service%rowtype) is
557: --
558: l_proc varchar2(80) := g_package||'set_object pds';
559: l_index pls_integer;
560: --

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

1879: procedure set_pps_object
1880: (p_person_id in number,
1881: p_business_group_id in number,
1882: p_effective_date in date,
1883: p_rec in out nocopy per_periods_of_service%rowtype) is
1884: --
1885: l_proc varchar2(80) := g_package||'set_pps_object';
1886: l_index pls_integer;
1887: --

Line 1890: from per_periods_of_service pps

1886: l_index pls_integer;
1887: --
1888: cursor c1 is
1889: select pps.*
1890: from per_periods_of_service pps
1891: where pps.person_id = p_person_id
1892: and pps.business_group_id = p_business_group_id
1893: and p_effective_date >= pps.date_start
1894: order by pps.date_start desc;

Line 1896: --l_rec per_periods_of_service%rowtype;

1892: and pps.business_group_id = p_business_group_id
1893: and p_effective_date >= pps.date_start
1894: order by pps.date_start desc;
1895: --
1896: --l_rec per_periods_of_service%rowtype;
1897: --115.23 - comment out unneeded record
1898: --
1899: begin
1900: --

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

2800: --
2801: end get_object;
2802: --
2803: procedure get_object(p_person_id in number,
2804: p_rec in out nocopy per_periods_of_service%rowtype) is
2805: --
2806: l_proc varchar2(80) := g_package||'get_object pds';
2807: l_index pls_integer;
2808: --l_not_hash_found boolean;

Line 2810: --l_rec per_periods_of_service%rowtype;

2806: l_proc varchar2(80) := g_package||'get_object pds';
2807: l_index pls_integer;
2808: --l_not_hash_found boolean;
2809: l_env ben_env_object.g_global_env_rec_type;
2810: --l_rec per_periods_of_service%rowtype;
2811: -- FONM
2812: l_effective_date date;
2813: --
2814: --

Line 3647: l_cache_last_pps_rec per_periods_of_service%rowtype;

3643: l_cache_last_per_rec per_all_people_f%rowtype;
3644: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3645: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3646: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3647: l_cache_last_pps_rec per_periods_of_service%rowtype;
3648: l_cache_last_pad_rec per_addresses%rowtype;
3649: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3650: l_cache_last_date_rec g_person_date_info_rec;
3651: l_cache_last_fte_rec g_person_fte_info_rec;

Line 3710: l_cache_last_pps_rec per_periods_of_service%rowtype;

3706: l_cache_last_per_rec per_all_people_f%rowtype;
3707: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3708: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3709: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3710: l_cache_last_pps_rec per_periods_of_service%rowtype;
3711: l_cache_last_pad_rec per_addresses%rowtype;
3712: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3713: l_cache_last_date_rec g_person_date_info_rec;
3714: l_cache_last_fte_rec g_person_fte_info_rec;