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_GENERAL

Line 74: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city

70: ,hlc.address_line_2 address_2
71: ,hlc.address_line_3 address_3
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

Line 161: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city

157: ,pad.address_line1 address_line1
158: ,pad.address_line2 address_line2
159: ,pad.address_line3 address_line3
160: ,pad.postal_code postcode
161: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city
162: ,pad.country country
163: FROM per_addresses pad
164: WHERE pad.person_id = p_payee_id
165: AND pad.primary_flag = 'Y'

Line 178: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city

174: ,hlc.address_line_2 address_2
175: ,hlc.address_line_3 address_3
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