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

Line 407: ,hr_locations hoi1

403: ,hoi1.address_line_3 address_line_3
404: ,hoi1.postal_code postal_code
405: ,SUBSTR(hlu.meaning, INSTR(hlu.meaning,' ', 1,1), LENGTH(hlu.meaning)-(INSTR(hlu.meaning,' ', 1,1)-1)) postal_office
406: FROM hr_organization_units o1
407: ,hr_locations hoi1
408: ,hr_organization_information hoi2
409: ,hr_lookups hlu
410: WHERE o1.business_group_id = l_business_group_id
411: AND hoi1.location_id = o1.location_id