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_PERUSEOX_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 187: from per_all_people_f peo

183: and hoi1.org_information_context = 'Reporting Statuses'
184: and hoi1.organization_id = P_BUSINESS_GROUP_ID);
185: cursor c_ethnic is
186: select 'Y'
187: from per_all_people_f peo
188: where
189: (
190: (peo.per_information1 is not null
191: and exists

Line 251: from per_all_people_f peo

247: cursor c_person_name is
248: select substr(peo.full_name,1,150) emp_name,
249: peo.employee_number emp_num,
250: peo.sex sex
251: from per_all_people_f peo
252: where peo.person_id = person_id1
253: and peo.business_group_id = P_BUSINESS_GROUP_ID
254: and report_date_end between peo.effective_start_date
255: and peo.effective_end_date

Line 283: ,per_all_people_f peo

279: and job.job_information_category(+) = 'US' ;
280: cursor c_eth_cat is
281: select nvl(lup.meaning, 'Not Specified') ethnic
282: from hr_lookups lup
283: ,per_all_people_f peo
284: where peo.person_id = person_id1
285: and peo.business_group_id = P_BUSINESS_GROUP_ID
286: and peo.per_information_category(+) = 'US'
287: and peo.per_information1 = lup.lookup_code(+)