DBA Data[Home] [Help]

APPS.BEN_EXT_ELIG_DPNT dependencies on PER_ADDRESSES

Line 189: from per_addresses a

185: , a.postal_code
186: , a.country
187: , a.date_from
188: , a.region_3
189: from per_addresses a
190: where
191: a.person_id = p_dpnt_person_id
192: and p_effective_date between nvl(a.date_from, p_effective_date)
193: and nvl(a.date_to, p_effective_date)

Line 208: from per_addresses a,

204: , a.postal_code
205: , a.country
206: , a.date_from
207: , a.region_3
208: from per_addresses a,
209: per_contact_relationships r
210: where
211: r.contact_person_id = p_dpnt_person_id
212: and r.person_id = p_person_id