APPS.BEN_EXT_PERSON dependencies on PER_ADDRESSES

Line 1502: from per_addresses a

1498: , a.last_updated_by
1499: , a.last_update_login
1500: , a.created_by
1501: , a.creation_date
1502: from per_addresses a
1503: where
1504: a.person_id = p_person_id
1505: and p_effective_date between nvl(a.date_from, p_effective_date)
1506: and nvl(a.date_to, p_effective_date)

Line 1524: from per_addresses a,

1520: , a.country
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

Line 1618: from per_addresses a

1614: , a.country
1615: , a.region_1
1616: , a.region_3
1617: , a.date_from
1618: from per_addresses a
1619: where
1620: a.person_id = p_person_id
1621: and p_effective_date between nvl(a.date_from, p_effective_date)
1622: and nvl(a.date_to, p_effective_date)

Line 1680: from per_addresses a

1676: , a.country
1677: , a.region_1
1678: , a.region_3
1679: , a.date_from
1680: from per_addresses a
1681: where
1682: a.address_id = p_address_id;
1683: --
1684: cursor c_prim_rltd_address is

Line 1696: from per_addresses a,

1692: , a.country
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