DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on HZ_GEOGRAPHY_TYPES_B

Line 6456: FROM hz_geography_types_b gt

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,

Line 6462: FROM hz_geography_types_b gt

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;

Line 6637: --FROM hz_geography_types_b

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