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 195: from per_all_people_f peo

191:
192: /* Commented for bug#11736960 starts
193: cursor c_ethnic is
194: select 'Y'
195: from per_all_people_f peo
196: where
197: (
198: (peo.per_information1 is not null
199: and exists

Line 263: from per_all_people_f peo

259: cursor c_person_name is
260: select substr(peo.full_name,1,150) emp_name,
261: peo.employee_number emp_num,
262: peo.sex sex
263: from per_all_people_f peo
264: where peo.person_id = person_id1
265: and peo.business_group_id = P_BUSINESS_GROUP_ID
266: and report_date_end between peo.effective_start_date
267: and peo.effective_end_date

Line 297: ,per_all_people_f peo

293: /* Commented for bug#11736960 starts
294: cursor c_eth_cat is
295: select nvl(lup.meaning, 'Not Specified') ethnic
296: from hr_lookups lup
297: ,per_all_people_f peo
298: where peo.person_id = person_id1
299: and peo.business_group_id = P_BUSINESS_GROUP_ID
300: and peo.per_information_category(+) = 'US'
301: and peo.per_information1 = lup.lookup_code(+)