APPS.PAY_IN_EOY_REPORTS dependencies on PER_ADDRESSES

Line 342: -- IN : p_location_id per_addresses.address_id --

338: -- Access : Private --
339: -- Description : This procedure gets the employee address details --
340: -- --
341: -- Parameters : --
342: -- IN : p_location_id per_addresses.address_id --
343: -- : p_concatenate VARCHAR2 --
344: -- p_field VARCHAR2 --
345: --------------------------------------------------------------------------
346: FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE

Line 346: FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE

342: -- IN : p_location_id per_addresses.address_id --
343: -- : p_concatenate VARCHAR2 --
344: -- p_field VARCHAR2 --
345: --------------------------------------------------------------------------
346: FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE
347: , p_concatenate IN VARCHAR2 DEFAULT 'N'
348: , p_field IN VARCHAR2 DEFAULT NULL
349: )
350: RETURN VARCHAR2

Line 363: FROM per_addresses pad

359: , pad.add_information14
360: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
361: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
362: , pad.postal_code
363: FROM per_addresses pad
364: WHERE pad.address_id = p_address_id;
365:
366: l_procedure VARCHAR2(100);
367: l_location_address1 hr_locations.address_line_1%TYPE;