DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_ADDRESSES

Line 1757: from per_addresses pa

1753: region_2,
1754: region_3,
1755: postal_code,
1756: country
1757: from per_addresses pa
1758: where pa.person_id = cp_person_id
1759: and pa.primary_flag = 'Y' --is address primary ?
1760: and cp_effective_date between pa.date_from
1761: and nvl(pa.date_to, cp_effective_date);