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.

[Home] [Help]

APPS.PER_PERRPFP4_XMLP_PKG dependencies on HR_LOOKUPS

Line 259: , hr_lookups hr1

255: || decode(peo.first_name,null,null,' ')
256: || peo.last_name
257: into v_authorizer_name
258: from per_all_people_f peo
259: , hr_lookups hr1
260: where AUTHORISING_PERSON_ID = peo.person_id
261: and peo.effective_start_date = (select min(peo2.effective_start_date)
262: from per_all_people_f peo2
263: where peo2.person_id = peo.person_id)

Line 277: , hr_lookups hr1

273: || decode(peo.first_name,null,null,' ')
274: || peo.last_name
275: into v_replacement_name
276: from per_all_people_f peo
277: , hr_lookups hr1
278: where replacement_PERSON_ID = peo.person_id
279: and peo.effective_start_date = (select min(peo2.effective_start_date)
280: from per_all_people_f peo2
281: where peo2.person_id = peo.person_id )