[Home] [Help]
533: AND log1.map_status = 'S'
534: AND ROWNUM = 1
535: ), 0), NVL(
536: (SELECT 2
537: FROM hz_geographies g
538: WHERE 3 = 3
539: AND g.country_code = loc.country
540: AND g.geography_type = 'COUNTRY'
541: AND ROWNUM = 1