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

Line 2235: -- address_record per_addresses%rowtype;

2231: f_zip varchar2(20) := NULL;
2232: f_zip_extension varchar2(4) := NULL;
2233: v_index number(5);
2234: --
2235: -- address_record per_addresses%rowtype;
2236: --
2237: v_address_line1 per_addresses.address_line1%TYPE;
2238: v_address_line2 per_addresses.address_line2%TYPE;
2239: v_address_line3 per_addresses.address_line3%TYPE;

Line 2237: v_address_line1 per_addresses.address_line1%TYPE;

2233: v_index number(5);
2234: --
2235: -- address_record per_addresses%rowtype;
2236: --
2237: v_address_line1 per_addresses.address_line1%TYPE;
2238: v_address_line2 per_addresses.address_line2%TYPE;
2239: v_address_line3 per_addresses.address_line3%TYPE;
2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;

Line 2238: v_address_line2 per_addresses.address_line2%TYPE;

2234: --
2235: -- address_record per_addresses%rowtype;
2236: --
2237: v_address_line1 per_addresses.address_line1%TYPE;
2238: v_address_line2 per_addresses.address_line2%TYPE;
2239: v_address_line3 per_addresses.address_line3%TYPE;
2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;

Line 2239: v_address_line3 per_addresses.address_line3%TYPE;

2235: -- address_record per_addresses%rowtype;
2236: --
2237: v_address_line1 per_addresses.address_line1%TYPE;
2238: v_address_line2 per_addresses.address_line2%TYPE;
2239: v_address_line3 per_addresses.address_line3%TYPE;
2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;
2243: v_postal_code per_addresses.postal_code%TYPE;

Line 2240: v_town_or_city per_addresses.town_or_city%TYPE;

2236: --
2237: v_address_line1 per_addresses.address_line1%TYPE;
2238: v_address_line2 per_addresses.address_line2%TYPE;
2239: v_address_line3 per_addresses.address_line3%TYPE;
2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;
2243: v_postal_code per_addresses.postal_code%TYPE;
2244: v_country per_addresses.country%TYPE;

Line 2241: v_region_2 per_addresses.region_2%TYPE;

2237: v_address_line1 per_addresses.address_line1%TYPE;
2238: v_address_line2 per_addresses.address_line2%TYPE;
2239: v_address_line3 per_addresses.address_line3%TYPE;
2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;
2243: v_postal_code per_addresses.postal_code%TYPE;
2244: v_country per_addresses.country%TYPE;
2245: v_style per_addresses.style%TYPE;

Line 2242: v_region_1 per_addresses.region_1%TYPE;

2238: v_address_line2 per_addresses.address_line2%TYPE;
2239: v_address_line3 per_addresses.address_line3%TYPE;
2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;
2243: v_postal_code per_addresses.postal_code%TYPE;
2244: v_country per_addresses.country%TYPE;
2245: v_style per_addresses.style%TYPE;
2246: --

Line 2243: v_postal_code per_addresses.postal_code%TYPE;

2239: v_address_line3 per_addresses.address_line3%TYPE;
2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;
2243: v_postal_code per_addresses.postal_code%TYPE;
2244: v_country per_addresses.country%TYPE;
2245: v_style per_addresses.style%TYPE;
2246: --
2247: cursor get_address_record is

Line 2244: v_country per_addresses.country%TYPE;

2240: v_town_or_city per_addresses.town_or_city%TYPE;
2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;
2243: v_postal_code per_addresses.postal_code%TYPE;
2244: v_country per_addresses.country%TYPE;
2245: v_style per_addresses.style%TYPE;
2246: --
2247: cursor get_address_record is
2248: select address_line1, address_line2, address_line3,

Line 2245: v_style per_addresses.style%TYPE;

2241: v_region_2 per_addresses.region_2%TYPE;
2242: v_region_1 per_addresses.region_1%TYPE;
2243: v_postal_code per_addresses.postal_code%TYPE;
2244: v_country per_addresses.country%TYPE;
2245: v_style per_addresses.style%TYPE;
2246: --
2247: cursor get_address_record is
2248: select address_line1, address_line2, address_line3,
2249: town_or_city, region_1, region_2, postal_code

Line 2251: from per_addresses

2247: cursor get_address_record is
2248: select address_line1, address_line2, address_line3,
2249: town_or_city, region_1, region_2, postal_code
2250: ,style
2251: from per_addresses
2252: where person_id = p_person_id
2253: and primary_flag = 'Y'
2254: and nvl(date_to, sysdate) >= sysdate;
2255: --

Line 2365: -- address_record per_addresses%rowtype;

2361: f_zip varchar2(20) := NULL;
2362: f_zip_extension varchar2(4) := NULL;
2363: v_index number(5);
2364: --
2365: -- address_record per_addresses%rowtype;
2366: --
2367: v_address_line1 per_addresses.address_line1%TYPE;
2368: v_address_line2 per_addresses.address_line2%TYPE;
2369: v_address_line3 per_addresses.address_line3%TYPE;

Line 2367: v_address_line1 per_addresses.address_line1%TYPE;

2363: v_index number(5);
2364: --
2365: -- address_record per_addresses%rowtype;
2366: --
2367: v_address_line1 per_addresses.address_line1%TYPE;
2368: v_address_line2 per_addresses.address_line2%TYPE;
2369: v_address_line3 per_addresses.address_line3%TYPE;
2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;

Line 2368: v_address_line2 per_addresses.address_line2%TYPE;

2364: --
2365: -- address_record per_addresses%rowtype;
2366: --
2367: v_address_line1 per_addresses.address_line1%TYPE;
2368: v_address_line2 per_addresses.address_line2%TYPE;
2369: v_address_line3 per_addresses.address_line3%TYPE;
2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;

Line 2369: v_address_line3 per_addresses.address_line3%TYPE;

2365: -- address_record per_addresses%rowtype;
2366: --
2367: v_address_line1 per_addresses.address_line1%TYPE;
2368: v_address_line2 per_addresses.address_line2%TYPE;
2369: v_address_line3 per_addresses.address_line3%TYPE;
2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;
2373: v_postal_code per_addresses.postal_code%TYPE;

Line 2370: v_town_or_city per_addresses.town_or_city%TYPE;

2366: --
2367: v_address_line1 per_addresses.address_line1%TYPE;
2368: v_address_line2 per_addresses.address_line2%TYPE;
2369: v_address_line3 per_addresses.address_line3%TYPE;
2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;
2373: v_postal_code per_addresses.postal_code%TYPE;
2374: v_country per_addresses.country%TYPE;

Line 2371: v_region_2 per_addresses.region_2%TYPE;

2367: v_address_line1 per_addresses.address_line1%TYPE;
2368: v_address_line2 per_addresses.address_line2%TYPE;
2369: v_address_line3 per_addresses.address_line3%TYPE;
2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;
2373: v_postal_code per_addresses.postal_code%TYPE;
2374: v_country per_addresses.country%TYPE;
2375: v_style per_addresses.style%TYPE;

Line 2372: v_region_1 per_addresses.region_1%TYPE;

2368: v_address_line2 per_addresses.address_line2%TYPE;
2369: v_address_line3 per_addresses.address_line3%TYPE;
2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;
2373: v_postal_code per_addresses.postal_code%TYPE;
2374: v_country per_addresses.country%TYPE;
2375: v_style per_addresses.style%TYPE;
2376: --

Line 2373: v_postal_code per_addresses.postal_code%TYPE;

2369: v_address_line3 per_addresses.address_line3%TYPE;
2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;
2373: v_postal_code per_addresses.postal_code%TYPE;
2374: v_country per_addresses.country%TYPE;
2375: v_style per_addresses.style%TYPE;
2376: --
2377: cursor get_address_record is

Line 2374: v_country per_addresses.country%TYPE;

2370: v_town_or_city per_addresses.town_or_city%TYPE;
2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;
2373: v_postal_code per_addresses.postal_code%TYPE;
2374: v_country per_addresses.country%TYPE;
2375: v_style per_addresses.style%TYPE;
2376: --
2377: cursor get_address_record is
2378: select address_line1, address_line2, address_line3,

Line 2375: v_style per_addresses.style%TYPE;

2371: v_region_2 per_addresses.region_2%TYPE;
2372: v_region_1 per_addresses.region_1%TYPE;
2373: v_postal_code per_addresses.postal_code%TYPE;
2374: v_country per_addresses.country%TYPE;
2375: v_style per_addresses.style%TYPE;
2376: --
2377: cursor get_address_record is
2378: select address_line1, address_line2, address_line3,
2379: town_or_city, region_1, region_2

Line 2381: from per_addresses

2377: cursor get_address_record is
2378: select address_line1, address_line2, address_line3,
2379: town_or_city, region_1, region_2
2380: , postal_code ,country ,style
2381: from per_addresses
2382: where person_id = p_person_id
2383: and primary_flag = 'Y'
2384: and nvl(date_to, sysdate) >= sysdate;
2385: --