DBA Data[Home] [Help]

APPS.PAY_CA_RL2_REG dependencies on PER_ADDRESSES

Line 917: from per_addresses addr

913: ,addr.town_or_city Town_or_City
914: ,decode(addr.country, 'CA', addr.region_1,
915: 'US', addr.region_2, addr.region_1 ) Province
916: ,addr.postal_code Postal_Code
917: from per_addresses addr
918: ,fnd_territories_vl country
919: where addr.person_id = p_person_id
920: and addr.primary_flag = 'Y'
921: and p_effective_date between