APPS.IRC_PARTY_API dependencies on PER_PHONES

Line 3467: or exists (select 1 from per_phones phns

3463: or (per1.date_of_birth is null and p_date_of_birth is null))
3464: and ( UPPER(per1.email_address)= UPPER(nvl(p_email_address,per1.email_address))
3465: or (per1.email_address is null and p_email_address is null))
3466: and (p_home_phone_number is null
3467: or exists (select 1 from per_phones phns
3468: where phns.parent_id=per1.person_id
3469: and phns.parent_table='PER_ALL_PEOPLE_F'
3470: and phns.phone_type in ('H1','H2','H3')
3471: and phns.phone_number = p_home_phone_number))

Line 3473: or exists (select 1 from per_phones phns

3469: and phns.parent_table='PER_ALL_PEOPLE_F'
3470: and phns.phone_type in ('H1','H2','H3')
3471: and phns.phone_number = p_home_phone_number))
3472: and (p_work_phone_number is null
3473: or exists (select 1 from per_phones phns
3474: where phns.parent_id=per1.person_id
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))