eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PERSON_OBJECT dependencies on PER_ALL_PEOPLE_F

Line 129: of per_all_people_f when there is no data present in

125: 120.0.12000000.9 03-Apr-12 usaraswa Bug 13889202: In procedure BEN_PERSON_OBJECT.SET_ALLASS_OBJECT
126: g_cache_all_ass_rec cache is not build correctly. Added code
127: to build the cache correctly.
128: 120.0.12000000.10 18-Apr-12 usaraswa Bug 13965664 Modified procedure set_typ_object to cache the date
129: of per_all_people_f when there is no data present in
130: per_person_type_usages_f for the person_id passed.
131: -----------------------------------------------------------------------------
132: */
133: --

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

137: g_debug boolean := hr_utility.debug_enabled;
138: --
139: -- Set object routines
140: --
141: procedure set_object(p_rec in out NOCOPY per_all_people_f%rowtype) is
142: --
143: l_proc varchar2(80) := g_package||'set_object per';
144: l_index pls_integer;
145: --

Line 1339: per_all_people_f ppf

1335: --
1336: cursor c1 is
1337: select con.*
1338: from per_contact_relationships con,
1339: per_all_people_f ppf
1340: where con.person_id = p_person_id
1341: and con.business_group_id = p_business_group_id
1342: and nvl(con.date_start,hr_api.g_sot) <= p_effective_date
1343: and ppf.person_id = con.contact_person_id

Line 1583: -- Considering per_all_people_f when there is no record at all in

1579: between per.effective_start_date
1580: and per.effective_end_date
1581: and per.person_type_id = ppt.person_type_id
1582: --Bug 13965664 start
1583: -- Considering per_all_people_f when there is no record at all in
1584: -- per_person_type_usages_f
1585: union
1586: select ppf.person_id,
1587: ppt.person_type_id,

Line 1591: from per_all_people_f ppf,

1587: ppt.person_type_id,
1588: ppt.user_person_type,
1589: ppt.system_person_type,
1590: decode(ppt.system_person_type,'EMP',1,2)
1591: from per_all_people_f ppf,
1592: per_person_types ppt
1593: where ppf.person_id = p_person_id
1594: and p_effective_date
1595: between ppf.effective_start_date

Line 1613: from per_all_people_f ppf,

1609: ppt.person_type_id,
1610: ppt.user_person_type,
1611: ppt.system_person_type,
1612: decode(ppt.system_person_type,'EMP',1,2)
1613: from per_all_people_f ppf,
1614: per_person_types ppt
1615: where ppf.person_id = p_person_id
1616: and p_effective_date
1617: between ppf.effective_start_date

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

1852: --
1853: procedure set_per_object(p_person_id in number,
1854: p_business_group_id in number,
1855: p_effective_date in date,
1856: p_rec in out nocopy per_all_people_f%rowtype) is
1857: --
1858: l_proc varchar2(80) := g_package||'set_per_object';
1859: l_index pls_integer;
1860: --

Line 1863: from per_all_people_f ppf

1859: l_index pls_integer;
1860: --
1861: cursor c1 is
1862: select ppf.*
1863: from per_all_people_f ppf
1864: where ppf.person_id = p_person_id
1865: and ppf.business_group_id = p_business_group_id
1866: and p_effective_date
1867: between ppf.effective_start_date

Line 1870: --l_rec per_all_people_f%rowtype;

1866: and p_effective_date
1867: between ppf.effective_start_date
1868: and ppf.effective_end_date;
1869: --
1870: --l_rec per_all_people_f%rowtype;
1871: --115.23 altered to use NOCOPY record
1872: begin
1873: --
1874: -- hr_utility.set_location('Entering '||l_proc,10);

Line 2020: from per_all_people_f ppf

2016: l_index pls_integer;
2017: --
2018: cursor c1 is
2019: select min(ppf.effective_start_date)
2020: from per_all_people_f ppf
2021: where ppf.person_id = p_person_id
2022: and ppf.business_group_id = p_business_group_id;
2023: --
2024: cursor c2 is

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

2199: --
2200: -- Get object routines
2201: --
2202: procedure get_object(p_person_id in number,
2203: p_rec in out nocopy per_all_people_f%rowtype) is
2204: l_proc varchar2(80) := g_package||'get_object per';
2205: l_index pls_integer;
2206: l_env ben_env_object.g_global_env_rec_type;
2207: --l_rec per_all_people_f%rowtype;

Line 2207: --l_rec per_all_people_f%rowtype;

2203: p_rec in out nocopy per_all_people_f%rowtype) is
2204: l_proc varchar2(80) := g_package||'get_object per';
2205: l_index pls_integer;
2206: l_env ben_env_object.g_global_env_rec_type;
2207: --l_rec per_all_people_f%rowtype;
2208: --
2209: -- FONM
2210: l_effective_date date;
2211: --

Line 3798: l_cache_last_per_rec per_all_people_f%rowtype;

3794: end get_object;
3795: --
3796: procedure clear_down_cache is
3797: --
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;

Line 3861: l_cache_last_per_rec per_all_people_f%rowtype;

3857: --
3858: procedure defrag_caches
3859: is
3860: --
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;