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.GHR_MTI_APP dependencies on PER_PEOPLE_F

Line 24: from per_people_f ppf

20: ppf.date_of_birth DATE_OF_BIRTH,
21: ppf.national_identifier NATIONAL_IDENTIFIER,
22: --Bug# 9329643
23: ppf.employee_number EMPLOYEE_NUMBER
24: from per_people_f ppf
25: where ppf.person_id = l_person_id
26: and l_effective_date between ppf.effective_start_date
27: and nvl(ppf.effective_end_date,l_effective_date+1);
28:

Line 166: l_last_name per_people_f.last_name%type;

162: l_position_occupied varchar2(100);
163: l_appropriation_code1 varchar2(100);
164: l_appropriation_code2 varchar2(100);
165:
166: l_last_name per_people_f.last_name%type;
167: l_first_name per_people_f.first_name%type;
168: l_full_name per_people_f.full_name%type;
169: l_middle_names per_people_f.middle_names%type;
170: l_date_of_birth varchar2(20);

Line 167: l_first_name per_people_f.first_name%type;

163: l_appropriation_code1 varchar2(100);
164: l_appropriation_code2 varchar2(100);
165:
166: l_last_name per_people_f.last_name%type;
167: l_first_name per_people_f.first_name%type;
168: l_full_name per_people_f.full_name%type;
169: l_middle_names per_people_f.middle_names%type;
170: l_date_of_birth varchar2(20);
171: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;

Line 168: l_full_name per_people_f.full_name%type;

164: l_appropriation_code2 varchar2(100);
165:
166: l_last_name per_people_f.last_name%type;
167: l_first_name per_people_f.first_name%type;
168: l_full_name per_people_f.full_name%type;
169: l_middle_names per_people_f.middle_names%type;
170: l_date_of_birth varchar2(20);
171: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;
172:

Line 169: l_middle_names per_people_f.middle_names%type;

165:
166: l_last_name per_people_f.last_name%type;
167: l_first_name per_people_f.first_name%type;
168: l_full_name per_people_f.full_name%type;
169: l_middle_names per_people_f.middle_names%type;
170: l_date_of_birth varchar2(20);
171: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;
172:
173: l_grade_id number;

Line 171: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;

167: l_first_name per_people_f.first_name%type;
168: l_full_name per_people_f.full_name%type;
169: l_middle_names per_people_f.middle_names%type;
170: l_date_of_birth varchar2(20);
171: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;
172:
173: l_grade_id number;
174: l_job_id number;
175: l_organization_id number;

Line 274: l_employee_number per_people_f.employee_number%type;

270: l_mt_status_err_cnt number := 0;
271: l_capped_other_pay number := hr_api.g_number;
272:
273: --Bug # 9329643
274: l_employee_number per_people_f.employee_number%type;
275: BEGIN
276: hr_utility.set_location('Entering ' || l_proc,5);
277: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
278: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||