DBA Data[Home] [Help]

APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on HR_LOCATIONS_ALL

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

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

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

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

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

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

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

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

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

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

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

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