APPS.BEN_PERSON_OBJECT dependencies on PER_ALL_PEOPLE_F

Line 119: procedure set_object(p_rec in out NOCOPY per_all_people_f%rowtype) is

115: g_debug boolean := hr_utility.debug_enabled;
116: --
117: -- Set object routines
118: --
119: procedure set_object(p_rec in out NOCOPY per_all_people_f%rowtype) is
120: --
121: l_proc varchar2(80) := g_package||'set_object per';
122: l_index pls_integer;
123: --

Line 1308: per_all_people_f ppf

1304: --
1305: cursor c1 is
1306: select con.*
1307: from per_contact_relationships con,
1308: per_all_people_f ppf
1309: where con.person_id = p_person_id
1310: and con.business_group_id = p_business_group_id
1311: and nvl(con.date_start,hr_api.g_sot) <= p_effective_date
1312: and ppf.person_id = con.contact_person_id

Line 1559: from per_all_people_f ppf,

1555: ppt.person_type_id,
1556: ppt.user_person_type,
1557: ppt.system_person_type,
1558: decode(ppt.system_person_type,'EMP',1,2)
1559: from per_all_people_f ppf,
1560: per_person_types ppt
1561: where ppf.person_id = p_person_id
1562: and p_effective_date
1563: between ppf.effective_start_date

Line 1802: p_rec in out nocopy per_all_people_f%rowtype) is

1798: --
1799: procedure set_per_object(p_person_id in number,
1800: p_business_group_id in number,
1801: p_effective_date in date,
1802: p_rec in out nocopy per_all_people_f%rowtype) is
1803: --
1804: l_proc varchar2(80) := g_package||'set_per_object';
1805: l_index pls_integer;
1806: --

Line 1809: from per_all_people_f ppf

1805: l_index pls_integer;
1806: --
1807: cursor c1 is
1808: select ppf.*
1809: from per_all_people_f ppf
1810: where ppf.person_id = p_person_id
1811: and ppf.business_group_id = p_business_group_id
1812: and p_effective_date
1813: between ppf.effective_start_date

Line 1816: --l_rec per_all_people_f%rowtype;

1812: and p_effective_date
1813: between ppf.effective_start_date
1814: and ppf.effective_end_date;
1815: --
1816: --l_rec per_all_people_f%rowtype;
1817: --115.23 altered to use NOCOPY record
1818: begin
1819: --
1820: -- hr_utility.set_location('Entering '||l_proc,10);

Line 1966: from per_all_people_f ppf

1962: l_index pls_integer;
1963: --
1964: cursor c1 is
1965: select min(ppf.effective_start_date)
1966: from per_all_people_f ppf
1967: where ppf.person_id = p_person_id
1968: and ppf.business_group_id = p_business_group_id;
1969: --
1970: cursor c2 is

Line 2149: p_rec in out nocopy per_all_people_f%rowtype) is

2145: --
2146: -- Get object routines
2147: --
2148: procedure get_object(p_person_id in number,
2149: p_rec in out nocopy per_all_people_f%rowtype) is
2150: l_proc varchar2(80) := g_package||'get_object per';
2151: l_index pls_integer;
2152: l_env ben_env_object.g_global_env_rec_type;
2153: --l_rec per_all_people_f%rowtype;

Line 2153: --l_rec per_all_people_f%rowtype;

2149: p_rec in out nocopy per_all_people_f%rowtype) is
2150: l_proc varchar2(80) := g_package||'get_object per';
2151: l_index pls_integer;
2152: l_env ben_env_object.g_global_env_rec_type;
2153: --l_rec per_all_people_f%rowtype;
2154: --
2155: -- FONM
2156: l_effective_date date;
2157: --

Line 3643: l_cache_last_per_rec per_all_people_f%rowtype;

3639: end get_object;
3640: --
3641: procedure clear_down_cache is
3642: --
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;

Line 3706: l_cache_last_per_rec per_all_people_f%rowtype;

3702: --
3703: procedure defrag_caches
3704: is
3705: --
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;