DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PER_ADDRESSES

Line 3051: from per_addresses addr,

3047: decode(addr.country,'CA', addr.region_1 , 'US' , addr.region_2 , ' '),
3048: replace(addr.postal_code,' '),
3049: addr.telephone_number_1,
3050: country.territory_code
3051: from per_addresses addr,
3052: fnd_territories_vl country
3053: where addr.person_id = l_person_id
3054: and addr.primary_flag = 'Y'
3055: and l_date_earned between nvl(addr.date_from, l_date_earned)