DBA Data[Home] [Help]

APPS.PAY_SG_SOE dependencies on HR_LOCATIONS

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

90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:
93: procedure get_work_address
94: (p_location_id in hr_locations.location_id%type,
95: p_address_line1 out nocopy hr_locations.address_line_1%type,
96: p_address_line2 out nocopy hr_locations.address_line_2%type,
97: p_address_line3 out nocopy hr_locations.address_line_3%type,
98: p_town_city out nocopy hr_locations.town_or_city%type,

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

91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:
93: procedure get_work_address
94: (p_location_id in hr_locations.location_id%type,
95: p_address_line1 out nocopy hr_locations.address_line_1%type,
96: p_address_line2 out nocopy hr_locations.address_line_2%type,
97: p_address_line3 out nocopy hr_locations.address_line_3%type,
98: p_town_city out nocopy hr_locations.town_or_city%type,
99: p_postal_code out nocopy hr_locations.postal_code%type,

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

92:
93: procedure get_work_address
94: (p_location_id in hr_locations.location_id%type,
95: p_address_line1 out nocopy hr_locations.address_line_1%type,
96: p_address_line2 out nocopy hr_locations.address_line_2%type,
97: p_address_line3 out nocopy hr_locations.address_line_3%type,
98: p_town_city out nocopy hr_locations.town_or_city%type,
99: p_postal_code out nocopy hr_locations.postal_code%type,
100: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);

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

93: procedure get_work_address
94: (p_location_id in hr_locations.location_id%type,
95: p_address_line1 out nocopy hr_locations.address_line_1%type,
96: p_address_line2 out nocopy hr_locations.address_line_2%type,
97: p_address_line3 out nocopy hr_locations.address_line_3%type,
98: p_town_city out nocopy hr_locations.town_or_city%type,
99: p_postal_code out nocopy hr_locations.postal_code%type,
100: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
101: function business_currency_code

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

94: (p_location_id in hr_locations.location_id%type,
95: p_address_line1 out nocopy hr_locations.address_line_1%type,
96: p_address_line2 out nocopy hr_locations.address_line_2%type,
97: p_address_line3 out nocopy hr_locations.address_line_3%type,
98: p_town_city out nocopy hr_locations.town_or_city%type,
99: p_postal_code out nocopy hr_locations.postal_code%type,
100: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
101: function business_currency_code
102: (p_business_group_id in hr_organization_units.business_group_id%type)

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

95: p_address_line1 out nocopy hr_locations.address_line_1%type,
96: p_address_line2 out nocopy hr_locations.address_line_2%type,
97: p_address_line3 out nocopy hr_locations.address_line_3%type,
98: p_town_city out nocopy hr_locations.town_or_city%type,
99: p_postal_code out nocopy hr_locations.postal_code%type,
100: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
101: function business_currency_code
102: (p_business_group_id in hr_organization_units.business_group_id%type)
103: return fnd_currencies.currency_code%type;