DBA Data[Home] [Help]

APPS.PAY_AU_SOE_PKG dependencies on HR_LOCATIONS

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

10: p_postal_code out NOCOPY per_addresses.postal_code%type,
11: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
12:
13: procedure get_work_address
14: (p_location_id in hr_locations.location_id%type,
15: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
16: p_address_line2 out NOCOPY hr_locations.address_line_2%type,
17: p_address_line3 out NOCOPY hr_locations.address_line_3%type,
18: p_town_city out NOCOPY hr_locations.town_or_city%type,

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

11: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
12:
13: procedure get_work_address
14: (p_location_id in hr_locations.location_id%type,
15: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
16: p_address_line2 out NOCOPY hr_locations.address_line_2%type,
17: p_address_line3 out NOCOPY hr_locations.address_line_3%type,
18: p_town_city out NOCOPY hr_locations.town_or_city%type,
19: p_postal_code out NOCOPY hr_locations.postal_code%type,

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

12:
13: procedure get_work_address
14: (p_location_id in hr_locations.location_id%type,
15: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
16: p_address_line2 out NOCOPY hr_locations.address_line_2%type,
17: p_address_line3 out NOCOPY hr_locations.address_line_3%type,
18: p_town_city out NOCOPY hr_locations.town_or_city%type,
19: p_postal_code out NOCOPY hr_locations.postal_code%type,
20: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);

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

13: procedure get_work_address
14: (p_location_id in hr_locations.location_id%type,
15: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
16: p_address_line2 out NOCOPY hr_locations.address_line_2%type,
17: p_address_line3 out NOCOPY hr_locations.address_line_3%type,
18: p_town_city out NOCOPY hr_locations.town_or_city%type,
19: p_postal_code out NOCOPY hr_locations.postal_code%type,
20: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
21:

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

14: (p_location_id in hr_locations.location_id%type,
15: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
16: p_address_line2 out NOCOPY hr_locations.address_line_2%type,
17: p_address_line3 out NOCOPY hr_locations.address_line_3%type,
18: p_town_city out NOCOPY hr_locations.town_or_city%type,
19: p_postal_code out NOCOPY hr_locations.postal_code%type,
20: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
21:
22: function get_salary

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

15: p_address_line1 out NOCOPY hr_locations.address_line_1%type,
16: p_address_line2 out NOCOPY hr_locations.address_line_2%type,
17: p_address_line3 out NOCOPY hr_locations.address_line_3%type,
18: p_town_city out NOCOPY hr_locations.town_or_city%type,
19: p_postal_code out NOCOPY hr_locations.postal_code%type,
20: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
21:
22: function get_salary
23: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,