DBA Data[Home] [Help]

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)