APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_GEOGRAPHY_RANGES

Line 3604: FROM hz_geography_ranges hgr

3600: zip.zip_end,
3601: zip.effective_from start_date,
3602: nvl(zip.effective_to,to_date('12/31/4712','mm/dd/yyyy')) end_date,
3603: (select hgr.rowid
3604: FROM hz_geography_ranges hgr
3605: WHERE hgr.GEOGRAPHY_ID = city.zone_geography_id
3606: --AND hgr.GEOGRAPHY_TYPE = NVL(p_tax_zone_type,'US_CITY_ZONE_TYPE_'||SUBSTRB(p_tax_regime_code, 14,10))
3607: --AND hgr.GEOGRAPHY_USE = 'TAX'
3608: --AND hgr.MASTER_REF_GEOGRAPHY_ID = city.geography_id

Line 3636: UPDATE hz_geography_ranges

3632: )
3633: LOOP
3634: IF (ref_ranges.hgr_row_id IS NOT NULL)
3635: THEN
3636: UPDATE hz_geography_ranges
3637: SET END_DATE = ref_ranges.end_date,
3638: LAST_UPDATED_BY = fnd_global.user_id,
3639: LAST_UPDATE_DATE = sysdate,
3640: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 3644: (SELECT 1 FROM HZ_GEOGRAPHY_RANGES

3640: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
3641: WHERE ROWID = ref_ranges.hgr_row_id;
3642: ELSE
3643: INSERT WHEN (NOT EXISTS
3644: (SELECT 1 FROM HZ_GEOGRAPHY_RANGES
3645: WHERE GEOGRAPHY_ID = ref_ranges.geography_id
3646: AND GEOGRAPHY_FROM = ref_ranges.zip_begin
3647: AND START_DATE = ref_ranges.start_date)
3648:

Line 3650: INTO hz_geography_ranges

3646: AND GEOGRAPHY_FROM = ref_ranges.zip_begin
3647: AND START_DATE = ref_ranges.start_date)
3648:
3649: ) THEN
3650: INTO hz_geography_ranges
3651: (
3652: GEOGRAPHY_ID,
3653: GEOGRAPHY_FROM,
3654: START_DATE,

Line 3696: INTO hz_geography_ranges

3692: -- Migrated regime case
3693: -- insert ranges for state/county/override jurisdictions too
3694: IF (p_tax_zone_type IS NULL) THEN
3695: INSERT ALL
3696: INTO hz_geography_ranges
3697: (
3698: GEOGRAPHY_ID,
3699: GEOGRAPHY_FROM,
3700: START_DATE,

Line 3747: FROM hz_geography_ranges hgr

3743: FROM ZX_DATA_UPLOAD_INTERFACE inter
3744: WHERE record_type in (1,3)
3745: AND zone_geography_id IS NOT NULL
3746: AND NOT EXISTS (SELECT NULL
3747: FROM hz_geography_ranges hgr
3748: WHERE hgr.GEOGRAPHY_ID = inter.zone_geography_id
3749: AND hgr.GEOGRAPHY_FROM = '0000'
3750: AND hgr.START_DATE = inter.effective_from
3751: );