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_SG_SOE dependencies on HR_LOCATIONS

Line 951: (p_location_id in hr_locations.location_id%type,

947: ------------------------------------------------------------------------
948: -- Selects the Work Address for the Person.
949: ------------------------------------------------------------------------
950: procedure get_work_address
951: (p_location_id in hr_locations.location_id%type,
952: p_address_line1 out nocopy hr_locations.address_line_1%type,
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,

Line 952: p_address_line1 out nocopy hr_locations.address_line_1%type,

948: -- Selects the Work Address for the Person.
949: ------------------------------------------------------------------------
950: procedure get_work_address
951: (p_location_id in hr_locations.location_id%type,
952: p_address_line1 out nocopy hr_locations.address_line_1%type,
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,

Line 953: p_address_line2 out nocopy hr_locations.address_line_2%type,

949: ------------------------------------------------------------------------
950: procedure get_work_address
951: (p_location_id in hr_locations.location_id%type,
952: p_address_line1 out nocopy hr_locations.address_line_1%type,
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

Line 954: p_address_line3 out nocopy hr_locations.address_line_3%type,

950: procedure get_work_address
951: (p_location_id in hr_locations.location_id%type,
952: p_address_line1 out nocopy hr_locations.address_line_1%type,
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:

Line 955: p_town_city out nocopy hr_locations.town_or_city%type,

951: (p_location_id in hr_locations.location_id%type,
952: p_address_line1 out nocopy hr_locations.address_line_1%type,
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

Line 956: p_postal_code out nocopy hr_locations.postal_code%type,

952: p_address_line1 out nocopy hr_locations.address_line_1%type,
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

Line 960: (c_location_id hr_locations.location_id%type) is

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,
962: hrl.address_line_2,
963: hrl.address_line_3,
964: hrl.town_or_city,

Line 967: from hr_locations hrl,

963: hrl.address_line_3,
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;