APPS.BEN_EXT_PERSON dependencies on PER_ADDRESSES

Line 1510: from per_addresses a

1506: , a.last_updated_by
1507: , a.last_update_login
1508: , a.created_by
1509: , a.creation_date
1510: from per_addresses a
1511: where
1512: a.person_id = p_person_id
1513: and p_effective_date between nvl(a.date_from, p_effective_date)
1514: and nvl(a.date_to, p_effective_date)

Line 1540: from per_addresses a,

1536: , a.country
1537: , a.region_1
1538: , a.region_3
1539: , a.date_from
1540: from per_addresses a,
1541: per_contact_relationships c,
1542: per_all_people_f p
1543: where
1544: c.contact_person_id = p_person_id

Line 1643: from per_addresses a

1639: , a.country
1640: , a.region_1
1641: , a.region_3
1642: , a.date_from
1643: from per_addresses a
1644: where
1645: a.person_id = p_person_id
1646: and p_effective_date between nvl(a.date_from, p_effective_date)
1647: and nvl(a.date_to, p_effective_date)

Line 1706: from per_addresses a

1702: , a.country
1703: , a.region_1
1704: , a.region_3
1705: , a.date_from
1706: from per_addresses a
1707: where
1708: a.address_id = p_address_id;
1709: --
1710: cursor c_prim_rltd_address is

Line 1722: from per_addresses a,

1718: , a.country
1719: , a.region_1
1720: , a.region_3
1721: , a.date_from
1722: from per_addresses a,
1723: per_contact_relationships r
1724: where
1725: r.contact_person_id = p_person_id
1726: and r.person_id = a.person_id