APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_GEOGRAPHY_RANGES

Line 3961: MERGE INTO hz_geography_ranges hgr USING

3957: );
3958:
3959: -- Changed the For Loop (present till version 26 of 12.0.X)
3960: -- into Merge statement for Bug#12861649
3961: MERGE INTO hz_geography_ranges hgr USING
3962: (SELECT master_ref_geography_id,
3963: geography_id,
3964: geography_type,
3965: zip_begin,

Line 3981: FROM hz_geography_ranges hgr

3977: zip.zip_end,
3978: zip.effective_from start_date,
3979: NVL(zip.effective_to,to_date('12/31/4712','mm/dd/yyyy')) end_date,
3980: (SELECT hgr.rowid
3981: FROM hz_geography_ranges hgr
3982: WHERE hgr.GEOGRAPHY_ID = city.zone_geography_id
3983: AND hgr.GEOGRAPHY_FROM = zip.zip_begin
3984: AND hgr.START_DATE = zip.effective_from
3985: AND ROWNUM=1

Line 4056: INTO hz_geography_ranges

4052: -- Migrated regime case
4053: -- insert ranges for state/county/override jurisdictions too
4054: IF (p_tax_zone_type IS NULL) THEN
4055: INSERT ALL
4056: INTO hz_geography_ranges
4057: (
4058: GEOGRAPHY_ID,
4059: GEOGRAPHY_FROM,
4060: START_DATE,

Line 4107: FROM hz_geography_ranges hgr

4103: FROM ZX_DATA_UPLOAD_INTERFACE inter
4104: WHERE record_type in (1,3)
4105: AND zone_geography_id IS NOT NULL
4106: AND NOT EXISTS (SELECT NULL
4107: FROM hz_geography_ranges hgr
4108: WHERE hgr.GEOGRAPHY_ID = inter.zone_geography_id
4109: AND hgr.GEOGRAPHY_FROM = '0000'
4110: AND hgr.START_DATE = inter.effective_from
4111: );