APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on PER_ADDRESSES

Line 235: addr_line_1 per_addresses.address_line1%type := NULL,

231: --
232: TYPE person_name_address IS RECORD (
233: full_name per_all_people_f.full_name%type := NULL,
234: employee_number per_all_people_f.employee_number%type := NULL,
235: addr_line_1 per_addresses.address_line1%type := NULL,
236: addr_line_2 per_addresses.address_line2%type := NULL,
237: addr_line_3 per_addresses.address_line3%type := NULL,
238: city per_addresses.town_or_city%type := NULL,
239: province_state varchar2(240) := NULL,

Line 236: addr_line_2 per_addresses.address_line2%type := NULL,

232: TYPE person_name_address IS RECORD (
233: full_name per_all_people_f.full_name%type := NULL,
234: employee_number per_all_people_f.employee_number%type := NULL,
235: addr_line_1 per_addresses.address_line1%type := NULL,
236: addr_line_2 per_addresses.address_line2%type := NULL,
237: addr_line_3 per_addresses.address_line3%type := NULL,
238: city per_addresses.town_or_city%type := NULL,
239: province_state varchar2(240) := NULL,
240: postal_code varchar2(240) := NULL,

Line 237: addr_line_3 per_addresses.address_line3%type := NULL,

233: full_name per_all_people_f.full_name%type := NULL,
234: employee_number per_all_people_f.employee_number%type := NULL,
235: addr_line_1 per_addresses.address_line1%type := NULL,
236: addr_line_2 per_addresses.address_line2%type := NULL,
237: addr_line_3 per_addresses.address_line3%type := NULL,
238: city per_addresses.town_or_city%type := NULL,
239: province_state varchar2(240) := NULL,
240: postal_code varchar2(240) := NULL,
241: country varchar2(240) := NULL,

Line 238: city per_addresses.town_or_city%type := NULL,

234: employee_number per_all_people_f.employee_number%type := NULL,
235: addr_line_1 per_addresses.address_line1%type := NULL,
236: addr_line_2 per_addresses.address_line2%type := NULL,
237: addr_line_3 per_addresses.address_line3%type := NULL,
238: city per_addresses.town_or_city%type := NULL,
239: province_state varchar2(240) := NULL,
240: postal_code varchar2(240) := NULL,
241: country varchar2(240) := NULL,
242: country_name varchar2(240) := NULL,

Line 243: region_1 per_addresses.region_1%type := NULL,

239: province_state varchar2(240) := NULL,
240: postal_code varchar2(240) := NULL,
241: country varchar2(240) := NULL,
242: country_name varchar2(240) := NULL,
243: region_1 per_addresses.region_1%type := NULL,
244: region_2 per_addresses.region_2%type := NULL,
245: valid_address varchar2(3) := 'N');
246: --
247: -- Function to get Person/Employee Address

Line 244: region_2 per_addresses.region_2%type := NULL,

240: postal_code varchar2(240) := NULL,
241: country varchar2(240) := NULL,
242: country_name varchar2(240) := NULL,
243: region_1 per_addresses.region_1%type := NULL,
244: region_2 per_addresses.region_2%type := NULL,
245: valid_address varchar2(3) := 'N');
246: --
247: -- Function to get Person/Employee Address
248: --