APPS.IRC_PARTY_API dependencies on PER_ADDRESSES

Line 3354: or exists (select 1 from per_addresses addr

3350: and phns.parent_table='PER_ALL_PEOPLE_F'
3351: and phns.phone_type in ('W1','W2','W3')
3352: and phns.phone_number = p_work_phone_number))
3353: and (p_address_line_1 is null
3354: or exists (select 1 from per_addresses addr
3355: where addr.person_id=per1.person_id
3356: and addr.address_type in ('H','REC','HOME')))
3357: and (p_manager_last_name is null
3358: or exists (select 1 from per_all_people_f per2