DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on PER_ADDRESSES

Line 803: from per_addresses addr

799: upper(hr_general.decode_lookup('GB_COUNTY', substr(addr.region_1,1,35))) county,
800: addr.postal_code post_code,
801: upper(addr.town_or_city) town_or_city,
802: upper(addr.country) country
803: from per_addresses addr
804: where addr.person_id(+) = p_person_id
805: and ( addr.primary_flag = 'Y'
806: or addr.primary_flag is null)
807: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))