APPS.PAY_CA_RL2_REG dependencies on FND_TERRITORIES_VL
Line 707: ,fnd_territories_vl country
703: ,decode(addr.country, 'CA', addr.region_1,
704: 'US', addr.region_2, addr.region_1 ) Province
705: ,addr.postal_code Postal_Code
706: from per_addresses addr 707: ,fnd_territories_vl country 708: where addr.person_id = p_person_id
709: and addr.primary_flag = 'Y'
710: and p_effective_date between
711: addr.date_from and nvl(addr.date_to, p_effective_date)