DBA Data[Home] [Help]

APPS.BEN_EXT_CONTACT dependencies on PER_ADDRESSES

Line 152: from per_addresses a

148: , a.postal_code
149: , a.country
150: , a.date_from
151: , a.region_3
152: from per_addresses a
153: where
154: a.person_id = p_contact_person_id
155: and p_effective_date between nvl(a.date_from, p_effective_date)
156: and nvl(a.date_to, p_effective_date)

Line 171: from per_addresses a,

167: , a.postal_code
168: , a.country
169: , a.date_from
170: , a.region_3
171: from per_addresses a,
172: per_contact_relationships r
173: where
174: r.contact_person_id = p_contact_person_id
175: and r.person_id = p_person_id