APPS.PAY_IN_EOY_REPORTS dependencies on PER_ADDRESSES

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

343: -- Access : Private --
344: -- Description : This procedure gets the employee address details --
345: -- --
346: -- Parameters : --
347: -- IN : p_location_id per_addresses.address_id --
348: -- : p_concatenate VARCHAR2 --
349: -- p_field VARCHAR2 --
350: --------------------------------------------------------------------------
351: FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE

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

347: -- IN : p_location_id per_addresses.address_id --
348: -- : p_concatenate VARCHAR2 --
349: -- p_field VARCHAR2 --
350: --------------------------------------------------------------------------
351: FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE
352: , p_concatenate IN VARCHAR2 DEFAULT 'N'
353: , p_field IN VARCHAR2 DEFAULT NULL
354: )
355: RETURN VARCHAR2

Line 368: FROM per_addresses pad

364: , pad.add_information14
365: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
366: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
367: , pad.postal_code
368: FROM per_addresses pad
369: WHERE pad.address_id = p_address_id;
370:
371: l_procedure VARCHAR2(100);
372: l_location_address1 hr_locations.address_line_1%TYPE;