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 22: from per_people_f ppf

18: ppf.middle_names MIDDLE_NAMES,
19: ppf.full_name FULL_NAME,
20: ppf.date_of_birth DATE_OF_BIRTH,
21: ppf.national_identifier NATIONAL_IDENTIFIER
22: from per_people_f ppf
23: where ppf.person_id = l_person_id
24: and l_effective_date between ppf.effective_start_date
25: and nvl(ppf.effective_end_date,l_effective_date+1);
26:

Line 143: l_last_name per_people_f.last_name%type;

139: l_position_occupied varchar2(100);
140: l_appropriation_code1 varchar2(100);
141: l_appropriation_code2 varchar2(100);
142:
143: l_last_name per_people_f.last_name%type;
144: l_first_name per_people_f.first_name%type;
145: l_full_name per_people_f.full_name%type;
146: l_middle_names per_people_f.middle_names%type;
147: l_date_of_birth varchar2(20);

Line 144: l_first_name per_people_f.first_name%type;

140: l_appropriation_code1 varchar2(100);
141: l_appropriation_code2 varchar2(100);
142:
143: l_last_name per_people_f.last_name%type;
144: l_first_name per_people_f.first_name%type;
145: l_full_name per_people_f.full_name%type;
146: l_middle_names per_people_f.middle_names%type;
147: l_date_of_birth varchar2(20);
148: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;

Line 145: l_full_name per_people_f.full_name%type;

141: l_appropriation_code2 varchar2(100);
142:
143: l_last_name per_people_f.last_name%type;
144: l_first_name per_people_f.first_name%type;
145: l_full_name per_people_f.full_name%type;
146: l_middle_names per_people_f.middle_names%type;
147: l_date_of_birth varchar2(20);
148: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;
149:

Line 146: l_middle_names per_people_f.middle_names%type;

142:
143: l_last_name per_people_f.last_name%type;
144: l_first_name per_people_f.first_name%type;
145: l_full_name per_people_f.full_name%type;
146: l_middle_names per_people_f.middle_names%type;
147: l_date_of_birth varchar2(20);
148: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;
149:
150: l_grade_id number;

Line 148: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;

144: l_first_name per_people_f.first_name%type;
145: l_full_name per_people_f.full_name%type;
146: l_middle_names per_people_f.middle_names%type;
147: l_date_of_birth varchar2(20);
148: l_national_identifier per_people_f.NATIONAL_IDENTIFIER%type;
149:
150: l_grade_id number;
151: l_job_id number;
152: l_organization_id number;