6452: FROM
6453: (SELECT gt.geography_type geography_type,
6454: gt.geography_use geography_use,
6455: 1 geography_type_num
6456: FROM hz_geography_types_b gt
6457: WHERE gt.geography_type = c_zone_geography_type
6458: UNION
6459: SELECT gt.geography_type geography_type,
6460: gt.geography_use geography_use,
6458: UNION
6459: SELECT gt.geography_type geography_type,
6460: gt.geography_use geography_use,
6461: 2 geography_type_num
6462: FROM hz_geography_types_b gt
6463: WHERE gt.geography_type = c_override_geo_type)
6464: ORDER BY 2 desc;
6465:
6466: l_event_class_rec ZX_API_PUB.event_class_rec_type;
6633: END IF; --l_acc_src_tax_rate_id is not null
6634:
6635: --SELECT count(1)
6636: --INTO l_geo_use_count
6637: --FROM hz_geography_types_b
6638: --WHERE geography_type = l_geography_type
6639: --AND geography_use <> 'MASTER_REF'
6640: --AND rownum = 1;
6641: BEGIN