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_IN_TAX_DECLARATION dependencies on PER_ADDRESSES

Line 262: -- Cursor to get the city type from per_addresses

258: ,p_effective_date IN DATE)
259: RETURN varchar2
260: IS
261: --
262: -- Cursor to get the city type from per_addresses
263: --
264: CURSOR csr_city_type
265: IS
266: SELECT add_information16

Line 267: FROM per_addresses

263: --
264: CURSOR csr_city_type
265: IS
266: SELECT add_information16
267: FROM per_addresses
268: WHERE person_id = p_person_id
269: AND primary_flag = 'Y'
270: AND style = 'IN'
271: AND p_effective_date BETWEEN date_from