DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PER_ADDRESSES

Line 2229: from per_addresses addr,

2225: decode(addr.country,'CA', addr.region_1 , 'US' , addr.region_2 , ' '),
2226: replace(addr.postal_code,' '),
2227: addr.telephone_number_1,
2228: country.territory_code
2229: from per_addresses addr,
2230: fnd_territories_vl country
2231: where addr.person_id = l_person_id
2232: and addr.primary_flag = 'Y'
2233: and l_date_earned between nvl(addr.date_from, l_date_earned)