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

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

53: ------------------------------------------------------------------------
54: -- Selects the Work Address for the Person.
55: ------------------------------------------------------------------------
56: procedure get_work_address
57: (p_location_id in hr_locations.location_id%type,
58: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
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,

Line 58: p_address_line1 out NOCOPY hr_locations.address_line_1%type,

54: -- Selects the Work Address for the Person.
55: ------------------------------------------------------------------------
56: procedure get_work_address
57: (p_location_id in hr_locations.location_id%type,
58: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
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,

Line 59: p_address_line2 out NOCOPY hr_locations.address_line_2%type,

55: ------------------------------------------------------------------------
56: procedure get_work_address
57: (p_location_id in hr_locations.location_id%type,
58: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
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

Line 60: p_address_line3 out NOCOPY hr_locations.address_line_3%type,

56: procedure get_work_address
57: (p_location_id in hr_locations.location_id%type,
58: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
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:

Line 61: p_town_city out NOCOPY hr_locations.town_or_city%type,

57: (p_location_id in hr_locations.location_id%type,
58: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
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

Line 62: p_postal_code out NOCOPY hr_locations.postal_code%type,

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

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

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,
68: hrl.address_line_2,
69: hrl.address_line_3,
70: hrl.town_or_city,

Line 73: from hr_locations hrl,

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