DBA Data[Home] [Help]

APPS.BEN_EXT_DPNT dependencies on PER_ADDRESSES

Line 178: from per_addresses a

174: , a.postal_code
175: , a.country
176: , a.date_from
177: , a.region_3
178: from per_addresses a
179: where
180: a.person_id = p_dpnt_person_id
181: and p_effective_date between nvl(a.date_from, p_effective_date)
182: and nvl(a.date_to, p_effective_date)

Line 197: from per_addresses a,

193: , a.postal_code
194: , a.country
195: , a.date_from
196: , a.region_3
197: from per_addresses a,
198: per_contact_relationships r
199: where
200: r.contact_person_id = p_dpnt_person_id
201: and r.person_id = p_person_id