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,
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,
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,
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,
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
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: --