DBA Data[Home] [Help]

APPS.BEN_EXT_BNF dependencies on PER_ADDRESSES

Line 155: from per_addresses a

151: , a.postal_code
152: , a.country
153: , a.date_from
154: , a.region_3
155: from per_addresses a
156: where
157: a.person_id = c_person_id
158: and p_effective_date between nvl(a.date_from, p_effective_date)
159: and nvl(a.date_to, p_effective_date)

Line 174: from per_addresses a,

170: , a.postal_code
171: , a.country
172: , a.date_from
173: , a.region_3
174: from per_addresses a,
175: per_contact_relationships r
176: where
177: r.contact_person_id = c_person_id
178: and r.person_id = a.person_id