DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_ADDRESSES

Line 1852: from per_addresses pa

1848: region_2,
1849: region_3,
1850: postal_code,
1851: country
1852: from per_addresses pa
1853: where pa.person_id = cp_person_id
1854: and pa.primary_flag = 'Y' --is address primary ?
1855: and cp_effective_date between pa.date_from
1856: and nvl(pa.date_to, cp_effective_date);