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_NL_PAYFILE_SEPA dependencies on HR_LOCATIONS

Line 76: FROM hr_locations hlc

72: ,hlc.region_1 street_name
73: ,hlc.postal_code postcode
74: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city
75: ,hlc.country country
76: FROM hr_locations hlc
77: ,hr_organization_units hou
78: WHERE hou.business_group_id = p_bg_id
79: AND hou.organization_id = p_org_id
80: AND hlc.location_id = hou.location_id;

Line 180: FROM hr_locations hlc

176: ,hlc.region_1 street_name
177: ,hlc.postal_code postcode
178: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city
179: ,hlc.country country
180: FROM hr_locations hlc
181: ,hr_organization_units hou
182: WHERE hou.business_group_id = p_bg_id
183: AND hou.organization_id = p_payee_id
184: AND hlc.location_id = hou.location_id;