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.PAY_NO_ARC_RSEA_07 dependencies on HR_LOCATIONS

Line 421: ,hr_locations hoi1

417: ,hoi1.address_line_3 address_line_3
418: ,hoi1.postal_code postal_code
419: ,SUBSTR(hlu.meaning, INSTR(hlu.meaning,' ', 1,1), LENGTH(hlu.meaning)-(INSTR(hlu.meaning,' ', 1,1)-1)) postal_office
420: FROM hr_organization_units o1
421: ,hr_locations hoi1
422: ,hr_organization_information hoi2
423: ,hr_lookups hlu
424: WHERE o1.business_group_id = l_business_group_id
425: AND hoi1.location_id = o1.location_id