DBA Data[Home] [Help]

APPS.PAY_CA_RL2_REG dependencies on FND_TERRITORIES_VL

Line 918: ,fnd_territories_vl country

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
922: addr.date_from and nvl(addr.date_to, p_effective_date)