DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PER_ADDRESSES

Line 1632: from per_addresses addr

1628: --
1629: cursor csr_ee_address (p_person_id number, p_asat_date date) is
1630: select addr.address_line1, addr.address_line2, addr.address_line3
1631: ,addr.region_2, addr.region_3, addr.town_or_city, addr.postal_code
1632: from per_addresses addr
1633: where addr.person_id = p_person_id
1634: and addr.primary_flag = 'Y'
1635: and p_asat_date >= addr.date_from
1636: and p_asat_date <= nvl(addr.date_to, p_asat_date);