DBA Data[Home] [Help]

APPS.JL_ZZ_AP_LIBRARY_1_PKG dependencies on HZ_GEOGRAPHIES

Line 29: from hz_geographies geo

25: ELSIF vscountry = 'BR' THEN
26: Begin
27: select 'exists'
28: into l_exists
29: from hz_geographies geo
30: where geo.country_code = 'BR'
31: and nvl(start_date, sysdate) <= sysdate
32: and nvl(end_date, sysdate) >= sysdate
33: and geo.geography_type = 'STATE'