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_EXTRA_INFO

Line 97: FROM PER_PEOPLE_EXTRA_INFO

93: CURSOR PER_EXTRA_CUR (p_mt_id number) is
94: SELECT PERSON_ID
95: , PERSON_EXTRA_INFO_ID
96: , OBJECT_VERSION_NUMBER
97: FROM PER_PEOPLE_EXTRA_INFO
98: WHERE PEI_INFORMATION6 = 'Y'
99: AND PEI_INFORMATION8 = to_char(p_mt_id)
100: AND INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
101:

Line 220: l_per_ei1_data per_people_extra_info%rowtype;

216:
217: l_pos_ei_data per_position_extra_info%rowtype;
218: l_pos_grp1_rec per_position_extra_info%rowtype;
219: l_pos_grp2_rec per_position_extra_info%rowtype;
220: l_per_ei1_data per_people_extra_info%rowtype;
221: l_per_ei2_data per_people_extra_info%rowtype;
222: l_per_ei3_data per_people_extra_info%rowtype;
223: l_per_ei4_data per_people_extra_info%rowtype;
224: l_per_ei5_data per_people_extra_info%rowtype;

Line 221: l_per_ei2_data per_people_extra_info%rowtype;

217: l_pos_ei_data per_position_extra_info%rowtype;
218: l_pos_grp1_rec per_position_extra_info%rowtype;
219: l_pos_grp2_rec per_position_extra_info%rowtype;
220: l_per_ei1_data per_people_extra_info%rowtype;
221: l_per_ei2_data per_people_extra_info%rowtype;
222: l_per_ei3_data per_people_extra_info%rowtype;
223: l_per_ei4_data per_people_extra_info%rowtype;
224: l_per_ei5_data per_people_extra_info%rowtype;
225:

Line 222: l_per_ei3_data per_people_extra_info%rowtype;

218: l_pos_grp1_rec per_position_extra_info%rowtype;
219: l_pos_grp2_rec per_position_extra_info%rowtype;
220: l_per_ei1_data per_people_extra_info%rowtype;
221: l_per_ei2_data per_people_extra_info%rowtype;
222: l_per_ei3_data per_people_extra_info%rowtype;
223: l_per_ei4_data per_people_extra_info%rowtype;
224: l_per_ei5_data per_people_extra_info%rowtype;
225:
226: l_education_level ghr_pa_requests.education_level%type;

Line 223: l_per_ei4_data per_people_extra_info%rowtype;

219: l_pos_grp2_rec per_position_extra_info%rowtype;
220: l_per_ei1_data per_people_extra_info%rowtype;
221: l_per_ei2_data per_people_extra_info%rowtype;
222: l_per_ei3_data per_people_extra_info%rowtype;
223: l_per_ei4_data per_people_extra_info%rowtype;
224: l_per_ei5_data per_people_extra_info%rowtype;
225:
226: l_education_level ghr_pa_requests.education_level%type;
227: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

Line 224: l_per_ei5_data per_people_extra_info%rowtype;

220: l_per_ei1_data per_people_extra_info%rowtype;
221: l_per_ei2_data per_people_extra_info%rowtype;
222: l_per_ei3_data per_people_extra_info%rowtype;
223: l_per_ei4_data per_people_extra_info%rowtype;
224: l_per_ei5_data per_people_extra_info%rowtype;
225:
226: l_education_level ghr_pa_requests.education_level%type;
227: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
228: l_academic_discipline ghr_pa_requests.academic_discipline%type;