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_US_GET_ITEM_DATA_PKG dependencies on HR_LOCATIONS_ALL

Line 265: addr_line_1 hr_locations_all.address_line_1%type := NULL,

261: -- MMREF Reporting and YE reports would use this record data type
262: -- Added phone_number field in the organization_name_address type for Bug#9356178
263: TYPE organization_name_address IS RECORD (
264: org_name hr_organization_units.name%type := NULL,
265: addr_line_1 hr_locations_all.address_line_1%type := NULL,
266: addr_line_2 hr_locations_all.address_line_2%type := NULL,
267: addr_line_3 hr_locations_all.address_line_3%type := NULL,
268: city hr_locations_all.town_or_city%type := NULL,
269: province_state varchar2(240) := NULL,

Line 266: addr_line_2 hr_locations_all.address_line_2%type := NULL,

262: -- Added phone_number field in the organization_name_address type for Bug#9356178
263: TYPE organization_name_address IS RECORD (
264: org_name hr_organization_units.name%type := NULL,
265: addr_line_1 hr_locations_all.address_line_1%type := NULL,
266: addr_line_2 hr_locations_all.address_line_2%type := NULL,
267: addr_line_3 hr_locations_all.address_line_3%type := NULL,
268: city hr_locations_all.town_or_city%type := NULL,
269: province_state varchar2(240) := NULL,
270: postal_code varchar2(240) := NULL,

Line 267: addr_line_3 hr_locations_all.address_line_3%type := NULL,

263: TYPE organization_name_address IS RECORD (
264: org_name hr_organization_units.name%type := NULL,
265: addr_line_1 hr_locations_all.address_line_1%type := NULL,
266: addr_line_2 hr_locations_all.address_line_2%type := NULL,
267: addr_line_3 hr_locations_all.address_line_3%type := NULL,
268: city hr_locations_all.town_or_city%type := NULL,
269: province_state varchar2(240) := NULL,
270: postal_code varchar2(240) := NULL,
271: country varchar2(240) := NULL,

Line 268: city hr_locations_all.town_or_city%type := NULL,

264: org_name hr_organization_units.name%type := NULL,
265: addr_line_1 hr_locations_all.address_line_1%type := NULL,
266: addr_line_2 hr_locations_all.address_line_2%type := NULL,
267: addr_line_3 hr_locations_all.address_line_3%type := NULL,
268: city hr_locations_all.town_or_city%type := NULL,
269: province_state varchar2(240) := NULL,
270: postal_code varchar2(240) := NULL,
271: country varchar2(240) := NULL,
272: region_1 hr_locations_all.region_1%type := NULL,

Line 272: region_1 hr_locations_all.region_1%type := NULL,

268: city hr_locations_all.town_or_city%type := NULL,
269: province_state varchar2(240) := NULL,
270: postal_code varchar2(240) := NULL,
271: country varchar2(240) := NULL,
272: region_1 hr_locations_all.region_1%type := NULL,
273: region_2 hr_locations_all.region_2%type := NULL,
274: phone_number hr_locations_all.telephone_number_1%type :=NULL,
275: valid_address varchar2(3) := 'N');
276: --

Line 273: region_2 hr_locations_all.region_2%type := NULL,

269: province_state varchar2(240) := NULL,
270: postal_code varchar2(240) := NULL,
271: country varchar2(240) := NULL,
272: region_1 hr_locations_all.region_1%type := NULL,
273: region_2 hr_locations_all.region_2%type := NULL,
274: phone_number hr_locations_all.telephone_number_1%type :=NULL,
275: valid_address varchar2(3) := 'N');
276: --
277: -- Function to get Organization/Employer Address

Line 274: phone_number hr_locations_all.telephone_number_1%type :=NULL,

270: postal_code varchar2(240) := NULL,
271: country varchar2(240) := NULL,
272: region_1 hr_locations_all.region_1%type := NULL,
273: region_2 hr_locations_all.region_2%type := NULL,
274: phone_number hr_locations_all.telephone_number_1%type :=NULL,
275: valid_address varchar2(3) := 'N');
276: --
277: -- Function to get Organization/Employer Address
278: --