APPS.IRC_PARTY_API dependencies on PER_PHONES

Line 3342: or exists (select 1 from per_phones phns

3338: or (per1.date_of_birth is null and p_date_of_birth is null))
3339: and (nvl(per1.email_address,p_email_address)=nvl(p_email_address,per1.email_address)
3340: or (per1.email_address is null and p_email_address is null))
3341: and (p_home_phone_number is null
3342: or exists (select 1 from per_phones phns
3343: where phns.parent_id=per1.person_id
3344: and phns.parent_table='PER_ALL_PEOPLE_F'
3345: and phns.phone_type in ('H1','H2','H3')
3346: and phns.phone_number = p_home_phone_number))

Line 3348: or exists (select 1 from per_phones phns

3344: and phns.parent_table='PER_ALL_PEOPLE_F'
3345: and phns.phone_type in ('H1','H2','H3')
3346: and phns.phone_number = p_home_phone_number))
3347: and (p_work_phone_number is null
3348: or exists (select 1 from per_phones phns
3349: where phns.parent_id=per1.person_id
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))