DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PER_ADDRESSES

Line 38: from per_addresses addr

34: upper(substr(trim(addr.address_line3),1,35)) addr3,
35: substr(addr.postal_code,1,10) post_code,
36: upper(substr(trim(addr.town_or_city),1,35)) addr4,
37: upper(substr(trim(addr.country),1,35)) country
38: from per_addresses addr
39: where addr.person_id = p_person_id
40: and ( addr.primary_flag = 'Y'
41: or addr.primary_flag is null)
42: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))