DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_CONTACT_RELATIONSHIPS

Line 1541: per_contact_relationships c,

1537: , a.region_1
1538: , a.region_3
1539: , a.date_from
1540: from per_addresses a,
1541: per_contact_relationships c,
1542: per_all_people_f p
1543: where
1544: c.contact_person_id = p_person_id
1545: and c.person_id = p.person_id

Line 1723: per_contact_relationships r

1719: , a.region_1
1720: , a.region_3
1721: , a.date_from
1722: from per_addresses a,
1723: per_contact_relationships r
1724: where
1725: r.contact_person_id = p_person_id
1726: and r.person_id = a.person_id
1727: and a.town_or_city is not null

Line 1884: ,per_contact_relationships r

1880: , per_phones h
1881: , per_phones w
1882: , per_phones f
1883: , per_phones m
1884: ,per_contact_relationships r
1885: where r.contact_person_id = p_person_id
1886: and r.rltd_per_rsds_w_dsgntr_flag = 'Y'
1887: and p.person_id = r.person_id
1888: and p_effective_date between nvl(p.effective_start_date, p_effective_date)