APPS.IRC_PARTY_API dependencies on PER_ADDRESSES

Line 3479: or exists (select 1 from per_addresses addr

3475: and phns.parent_table='PER_ALL_PEOPLE_F'
3476: and phns.phone_type in ('W1','W2','W3')
3477: and phns.phone_number = p_work_phone_number))
3478: and (p_address_line_1 is null
3479: or exists (select 1 from per_addresses addr
3480: where addr.person_id=per1.person_id
3481: and addr.address_type in ('H','REC','HOME')))
3482: and (p_manager_last_name is null
3483: or exists (select 1 from per_all_people_f per2