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.PER_CN_ADD_LEG_HOOK dependencies on PER_ADDRESSES

Line 256: l_style per_addresses.style%TYPE := 'CN_GLB';

252: ,p_country IN VARCHAR2
253: ,p_postal_code IN VARCHAR2)
254: IS
255:
256: l_style per_addresses.style%TYPE := 'CN_GLB';
257:
258: --
259: -- Bug 3371417
260: -- Added Cursor to fetch addres style from per_addresses

Line 260: -- Added Cursor to fetch addres style from per_addresses

256: l_style per_addresses.style%TYPE := 'CN_GLB';
257:
258: --
259: -- Bug 3371417
260: -- Added Cursor to fetch addres style from per_addresses
261: --
262: l_proc VARCHAR2(72) := g_package||'check_address_upd';
263:
264: CURSOR csr_addr_style(p_address_id NUMBER)IS

Line 266: FROM per_addresses addr

262: l_proc VARCHAR2(72) := g_package||'check_address_upd';
263:
264: CURSOR csr_addr_style(p_address_id NUMBER)IS
265: SELECT addr.style
266: FROM per_addresses addr
267: WHERE addr.address_id = p_address_id ;
268:
269:
270: BEGIN