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.PER_FR_PEOPLE_LEG_HOOK dependencies on PER_ALL_PEOPLE_F

Line 99: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;

95:
96: l_proc VARCHAR2(200) := g_package||'check_regn_entry_upd';
97: l_dept hr_lookups.meaning%TYPE;
98: l_dept_code hr_lookups.lookup_code%TYPE;
99: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;
100: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
101: l_old_information10 per_all_people_f.per_information10%TYPE;
102: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;
103: l_use_country_of_birth per_all_people_f.country_of_birth%TYPE;

Line 100: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;

96: l_proc VARCHAR2(200) := g_package||'check_regn_entry_upd';
97: l_dept hr_lookups.meaning%TYPE;
98: l_dept_code hr_lookups.lookup_code%TYPE;
99: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;
100: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
101: l_old_information10 per_all_people_f.per_information10%TYPE;
102: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;
103: l_use_country_of_birth per_all_people_f.country_of_birth%TYPE;
104: l_use_information10 per_all_people_f.per_information10%TYPE;

Line 101: l_old_information10 per_all_people_f.per_information10%TYPE;

97: l_dept hr_lookups.meaning%TYPE;
98: l_dept_code hr_lookups.lookup_code%TYPE;
99: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;
100: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
101: l_old_information10 per_all_people_f.per_information10%TYPE;
102: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;
103: l_use_country_of_birth per_all_people_f.country_of_birth%TYPE;
104: l_use_information10 per_all_people_f.per_information10%TYPE;
105:

Line 102: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;

98: l_dept_code hr_lookups.lookup_code%TYPE;
99: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;
100: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
101: l_old_information10 per_all_people_f.per_information10%TYPE;
102: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;
103: l_use_country_of_birth per_all_people_f.country_of_birth%TYPE;
104: l_use_information10 per_all_people_f.per_information10%TYPE;
105:
106: CURSOR cur_dept IS

Line 103: l_use_country_of_birth per_all_people_f.country_of_birth%TYPE;

99: l_old_region_of_birth per_all_people_f.region_of_birth%TYPE;
100: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
101: l_old_information10 per_all_people_f.per_information10%TYPE;
102: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;
103: l_use_country_of_birth per_all_people_f.country_of_birth%TYPE;
104: l_use_information10 per_all_people_f.per_information10%TYPE;
105:
106: CURSOR cur_dept IS
107: select hl.meaning, hl.lookup_code

Line 104: l_use_information10 per_all_people_f.per_information10%TYPE;

100: l_old_country_of_birth per_all_people_f.country_of_birth%TYPE;
101: l_old_information10 per_all_people_f.per_information10%TYPE;
102: l_use_region_of_birth per_all_people_f.region_of_birth%TYPE;
103: l_use_country_of_birth per_all_people_f.country_of_birth%TYPE;
104: l_use_information10 per_all_people_f.per_information10%TYPE;
105:
106: CURSOR cur_dept IS
107: select hl.meaning, hl.lookup_code
108: from hr_lookups hl

Line 134: from per_all_people_f

130: hr_utility.trace('date:'|| to_char(p_effective_date));
131: -- get the old values, or the updated new values - remove the default placeholders
132: select region_of_birth, country_of_birth, per_information10
133: into l_old_region_of_birth, l_old_country_of_birth, l_old_information10
134: from per_all_people_f
135: where person_id = p_person_id
136: and p_effective_Date between effective_start_date and effective_end_Date;
137: -- only use the old values if the new are not changing
138: IF val_changed(p_region_of_birth) THEN