APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_ADAPTER_TERRITORIES

Line 1685: from HZ_ADAPTERS la, HZ_ADAPTER_TERRITORIES t

1681: l_dummy VARCHAR2(1);
1682:
1683: CURSOR get_country_adapter(l_country_code VARCHAR2) IS
1684: select la.adapter_id
1685: from HZ_ADAPTERS la, HZ_ADAPTER_TERRITORIES t
1686: where la.adapter_id = t.adapter_id
1687: and t.territory_code = l_country_code
1688: and t.enabled_flag = 'Y'
1689: and t.default_flag = 'Y'