APPS.PER_PERSON_INFORMATION dependencies on PER_ADDRESSES

Line 160: FROM per_addresses

156: ,to_char(date_from,'MM/DD/YYYY') d_f
157: ,NVL(to_char(date_to,'MM/DD/YYYY'), '12/31/4712') d_t
158: ,party_id p_id
159: ,nvl(address_type,null) a_d
160: FROM per_addresses
161: WHERE
162: person_id = p_person_id
163: ORDER BY date_from;
164:

Line 452: l_body := l_body || ' Address Details - per_addresses ';

448: -- Address Details
449:
450: l_body := '';
451:
452: l_body := l_body || '';
453:
454: l_body := l_body || ''
455: || ''
456: || ''

Address Details - per_addresses
' || 'Address Id' || '	' || 'Primary' || '