DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_CONTACT_RELATIONSHIPS

Line 1525: per_contact_relationships c,

1521: , a.region_1
1522: , a.region_3
1523: , a.date_from
1524: from per_addresses a,
1525: per_contact_relationships c,
1526: per_all_people_f p
1527: where
1528: c.contact_person_id = p_person_id
1529: and c.person_id = p.person_id

Line 1697: per_contact_relationships r

1693: , a.region_1
1694: , a.region_3
1695: , a.date_from
1696: from per_addresses a,
1697: per_contact_relationships r
1698: where
1699: r.contact_person_id = p_person_id
1700: and r.person_id = a.person_id
1701: and a.town_or_city is not null

Line 1851: ,per_contact_relationships r

1847: , per_phones h
1848: , per_phones w
1849: , per_phones f
1850: , per_phones m
1851: ,per_contact_relationships r
1852: where r.contact_person_id = p_person_id
1853: and r.rltd_per_rsds_w_dsgntr_flag = 'Y'
1854: and p.person_id = r.person_id
1855: and p_effective_date between nvl(p.effective_start_date, p_effective_date)