[Home] [Help]
916: p_address_line2 out nocopy per_addresses.address_line2%type,
917: p_address_line3 out nocopy per_addresses.address_line3%type,
918: p_town_city out nocopy per_addresses.town_or_city%type,
919: p_postal_code out nocopy per_addresses.postal_code%type,
920: p_country_name out nocopy fnd_territories_tl.territory_short_name%type) is
921:
922: cursor home_address
923: (c_person_id per_addresses.person_id%type) is
924: select pad.address_line1,
927: pad.town_or_city,
928: pad.postal_code,
929: ftt.territory_short_name
930: from per_addresses pad,
931: fnd_territories_tl ftt
932: where pad.person_id = c_person_id
933: and ftt.language = userenv('LANG')
934: and ftt.territory_code = pad.country
935: and sysdate between nvl(pad.date_from, sysdate) and nvl(pad.date_to, sysdate);
953: p_address_line2 out nocopy hr_locations.address_line_2%type,
954: p_address_line3 out nocopy hr_locations.address_line_3%type,
955: p_town_city out nocopy hr_locations.town_or_city%type,
956: p_postal_code out nocopy hr_locations.postal_code%type,
957: p_country_name out nocopy fnd_territories_tl.territory_short_name%type) is
958:
959: cursor c_get_work_address
960: (c_location_id hr_locations.location_id%type) is
961: select hrl.address_line_1,
964: hrl.town_or_city,
965: hrl.postal_code,
966: ftt.territory_short_name
967: from hr_locations hrl,
968: fnd_territories_tl ftt
969: where hrl.location_id = c_location_id
970: and ftt.language (+) = userenv('LANG')
971: and ftt.territory_code (+) = hrl.country;
972: