APPS.PAY_IN_SOE dependencies on PER_ADDRESSES

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

307: -- Access : Private --
308: -- Description : This procedure gets the employee address details --
309: -- --
310: -- Parameters : --
311: -- IN : p_location_id per_addresses.address_id --
312: -- : p_concatenate VARCHAR2 --
313: -- p_field VARCHAR2 --
314: --------------------------------------------------------------------------
315: FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE

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

311: -- IN : p_location_id per_addresses.address_id --
312: -- : p_concatenate VARCHAR2 --
313: -- p_field VARCHAR2 --
314: --------------------------------------------------------------------------
315: FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE
316: , p_concatenate IN VARCHAR2 DEFAULT 'N'
317: , p_field IN VARCHAR2 DEFAULT NULL
318: )
319: RETURN VARCHAR2

Line 332: FROM per_addresses pad

328: , pad.add_information14
329: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
330: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
331: , pad.postal_code
332: FROM per_addresses pad
333: WHERE pad.address_id = p_address_id;
334:
335: l_procedure VARCHAR2(100);
336: l_location_address1 hr_locations.address_line_1%TYPE;

Line 433: l_emp_addr_id per_addresses.address_id%TYPE ;

429: --
430: l_procedure VARCHAR2(100);
431: l_message VARCHAR2(250);
432: l_emp_addr VARCHAR2(500) := NULL ;
433: l_emp_addr_id per_addresses.address_id%TYPE ;
434:
435: CURSOR c_employee_address
436: IS
437: SELECT pa.address_id

Line 438: FROM per_addresses pa

434:
435: CURSOR c_employee_address
436: IS
437: SELECT pa.address_id
438: FROM per_addresses pa
439: WHERE pa.person_id = p_person_id
440: AND pa.address_type = DECODE(pa.address_type,'IN_P','IN_P','IN_C')
441: AND TO_DATE(p_date) BETWEEN pa.date_from AND nvl(pa.date_to,to_date('31-12-4712','DD-MM-YYYY'))
442: ORDER BY address_type DESC;