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 261: -- Cursor to get the city type from per_addresses

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

Line 266: FROM per_addresses

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