[Home] [Help]
21: p_address_line2 out NOCOPY per_addresses.address_line2%type,
22: p_address_line3 out NOCOPY per_addresses.address_line3%type,
23: p_town_city out NOCOPY per_addresses.town_or_city%type,
24: p_postal_code out NOCOPY per_addresses.postal_code%type,
25: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type) is
26:
27: cursor home_address
28: (c_person_id per_addresses.person_id%type) is
29: select pad.address_line1,
32: pad.town_or_city,
33: pad.postal_code,
34: ftt.territory_short_name
35: from per_addresses pad,
36: fnd_territories_tl ftt
37: where pad.person_id = c_person_id
38: and ftt.language = userenv('LANG')
39: and ftt.territory_code = pad.country
40: and sysdate between nvl(pad.date_from, sysdate) and nvl(pad.date_to, sysdate);
59: p_address_line2 out NOCOPY hr_locations.address_line_2%type,
60: p_address_line3 out NOCOPY hr_locations.address_line_3%type,
61: p_town_city out NOCOPY hr_locations.town_or_city%type,
62: p_postal_code out NOCOPY hr_locations.postal_code%type,
63: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type) is
64:
65: cursor c_get_work_address
66: (c_location_id hr_locations.location_id%type) is
67: select hrl.address_line_1,
70: hrl.town_or_city,
71: hrl.postal_code,
72: ftt.territory_short_name
73: from hr_locations hrl,
74: fnd_territories_tl ftt
75: where hrl.location_id = c_location_id
76: and ftt.language = userenv('LANG')
77: and ftt.territory_code = hrl.country;
78: