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 103: FROM PER_PEOPLE_EXTRA_INFO

99: CURSOR PER_EXTRA_CUR (p_mt_id number) is
100: SELECT PERSON_ID
101: , PERSON_EXTRA_INFO_ID
102: , OBJECT_VERSION_NUMBER
103: FROM PER_PEOPLE_EXTRA_INFO
104: WHERE PEI_INFORMATION6 = 'Y'
105: AND PEI_INFORMATION8 = to_char(p_mt_id)
106: AND INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
107:

Line 243: l_per_ei1_data per_people_extra_info%rowtype;

239:
240: l_pos_ei_data per_position_extra_info%rowtype;
241: l_pos_grp1_rec per_position_extra_info%rowtype;
242: l_pos_grp2_rec per_position_extra_info%rowtype;
243: l_per_ei1_data per_people_extra_info%rowtype;
244: l_per_ei2_data per_people_extra_info%rowtype;
245: l_per_ei3_data per_people_extra_info%rowtype;
246: l_per_ei4_data per_people_extra_info%rowtype;
247: l_per_ei5_data per_people_extra_info%rowtype;

Line 244: l_per_ei2_data per_people_extra_info%rowtype;

240: l_pos_ei_data per_position_extra_info%rowtype;
241: l_pos_grp1_rec per_position_extra_info%rowtype;
242: l_pos_grp2_rec per_position_extra_info%rowtype;
243: l_per_ei1_data per_people_extra_info%rowtype;
244: l_per_ei2_data per_people_extra_info%rowtype;
245: l_per_ei3_data per_people_extra_info%rowtype;
246: l_per_ei4_data per_people_extra_info%rowtype;
247: l_per_ei5_data per_people_extra_info%rowtype;
248:

Line 245: l_per_ei3_data per_people_extra_info%rowtype;

241: l_pos_grp1_rec per_position_extra_info%rowtype;
242: l_pos_grp2_rec per_position_extra_info%rowtype;
243: l_per_ei1_data per_people_extra_info%rowtype;
244: l_per_ei2_data per_people_extra_info%rowtype;
245: l_per_ei3_data per_people_extra_info%rowtype;
246: l_per_ei4_data per_people_extra_info%rowtype;
247: l_per_ei5_data per_people_extra_info%rowtype;
248:
249: l_education_level ghr_pa_requests.education_level%type;

Line 246: l_per_ei4_data per_people_extra_info%rowtype;

242: l_pos_grp2_rec per_position_extra_info%rowtype;
243: l_per_ei1_data per_people_extra_info%rowtype;
244: l_per_ei2_data per_people_extra_info%rowtype;
245: l_per_ei3_data per_people_extra_info%rowtype;
246: l_per_ei4_data per_people_extra_info%rowtype;
247: l_per_ei5_data per_people_extra_info%rowtype;
248:
249: l_education_level ghr_pa_requests.education_level%type;
250: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

Line 247: l_per_ei5_data per_people_extra_info%rowtype;

243: l_per_ei1_data per_people_extra_info%rowtype;
244: l_per_ei2_data per_people_extra_info%rowtype;
245: l_per_ei3_data per_people_extra_info%rowtype;
246: l_per_ei4_data per_people_extra_info%rowtype;
247: l_per_ei5_data per_people_extra_info%rowtype;
248:
249: l_education_level ghr_pa_requests.education_level%type;
250: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
251: l_academic_discipline ghr_pa_requests.academic_discipline%type;