APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_GEOGRAPHY_IDENTIFIERS

Line 2352: INTO HZ_GEOGRAPHY_IDENTIFIERS

2348: fnd_global.user_id,
2349: sysdate,
2350: fnd_global.conc_login_id
2351: )
2352: INTO HZ_GEOGRAPHY_IDENTIFIERS
2353: (
2354: GEOGRAPHY_ID,
2355: GEO_DATA_PROVIDER,
2356: IDENTIFIER_SUBTYPE,

Line 2438: INTO HZ_GEOGRAPHY_IDENTIFIERS

2434: fnd_global.conc_login_id,
2435: p_tax_content_source
2436: )
2437: WHEN (action_type = 'UPDATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2438: INTO HZ_GEOGRAPHY_IDENTIFIERS
2439: (
2440: GEOGRAPHY_ID,
2441: GEO_DATA_PROVIDER,
2442: IDENTIFIER_SUBTYPE,

Line 2477: INTO HZ_GEOGRAPHY_IDENTIFIERS

2473: sysdate,
2474: fnd_global.conc_login_id
2475: )
2476: WHEN (action_type = 'UPDATE' AND geography_type IN ('COUNTY','CITY') AND geography_name IS NOT NULL) THEN
2477: INTO HZ_GEOGRAPHY_IDENTIFIERS
2478: (
2479: GEOGRAPHY_ID,
2480: GEO_DATA_PROVIDER,
2481: IDENTIFIER_SUBTYPE,

Line 2516: INTO HZ_GEOGRAPHY_IDENTIFIERS

2512: sysdate,
2513: fnd_global.conc_login_id
2514: )
2515: WHEN (action_type = 'CREATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2516: INTO HZ_GEOGRAPHY_IDENTIFIERS
2517: (
2518: GEOGRAPHY_ID,
2519: GEO_DATA_PROVIDER,
2520: IDENTIFIER_SUBTYPE,

Line 2554: INTO HZ_GEOGRAPHY_IDENTIFIERS

2550: fnd_global.user_id,
2551: sysdate,
2552: fnd_global.conc_login_id
2553: )
2554: INTO HZ_GEOGRAPHY_IDENTIFIERS
2555: (
2556: GEOGRAPHY_ID,
2557: GEO_DATA_PROVIDER,
2558: IDENTIFIER_SUBTYPE,

Line 2928: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi

2924: CASE WHEN status = 'CREATE'
2925: THEN 'CREATE'
2926: WHEN status = 'UPDATE' AND
2927: 'EXISTS' = (SELECT 'EXISTS'
2928: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
2929: WHERE hgi.geography_id = v.geography_id
2930: AND hgi.identifier_type = 'NAME'
2931: AND hgi.identifier_subtype = 'STANDARD_NAME'
2932: AND UPPER(hgi.identifier_value) = UPPER(DECODE(geography_type,'STATE',geography_name1,geography_name)))

Line 3237: INTO HZ_GEOGRAPHY_IDENTIFIERS

3233: fnd_global.conc_login_id
3234: )
3235: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL
3236: AND existing_geography_id IS NULL and primary_flag = 'Y') THEN
3237: INTO HZ_GEOGRAPHY_IDENTIFIERS
3238: (
3239: GEOGRAPHY_ID,
3240: GEO_DATA_PROVIDER,
3241: IDENTIFIER_SUBTYPE,

Line 3277: INTO HZ_GEOGRAPHY_IDENTIFIERS

3273: fnd_global.conc_login_id
3274: )
3275: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL
3276: AND existing_geography_id IS NULL and primary_flag = 'Y') THEN
3277: INTO HZ_GEOGRAPHY_IDENTIFIERS
3278: (
3279: GEOGRAPHY_ID,
3280: GEO_DATA_PROVIDER,
3281: IDENTIFIER_SUBTYPE,

Line 4285: INTO HZ_GEOGRAPHY_IDENTIFIERS

4281: fnd_global.user_id,
4282: sysdate,
4283: fnd_global.conc_login_id
4284: )
4285: INTO HZ_GEOGRAPHY_IDENTIFIERS
4286: (
4287: GEOGRAPHY_ID,
4288: GEO_DATA_PROVIDER,
4289: IDENTIFIER_SUBTYPE,

Line 4323: INTO HZ_GEOGRAPHY_IDENTIFIERS

4319: fnd_global.user_id,
4320: sysdate,
4321: fnd_global.conc_login_id
4322: )
4323: INTO HZ_GEOGRAPHY_IDENTIFIERS
4324: (
4325: GEOGRAPHY_ID,
4326: GEO_DATA_PROVIDER,
4327: IDENTIFIER_SUBTYPE,

Line 4916: INTO HZ_GEOGRAPHY_IDENTIFIERS

4912: 'Creating Alternate Cities.'
4913: );
4914:
4915: INSERT ALL
4916: INTO HZ_GEOGRAPHY_IDENTIFIERS
4917: (
4918: GEOGRAPHY_ID,
4919: GEO_DATA_PROVIDER,
4920: IDENTIFIER_SUBTYPE,

Line 4962: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi

4958: WHERE inter.record_type = 07
4959: AND inter.last_updation_version > p_last_run_version
4960: AND inter.geography_id IS NOT NULL
4961: AND NOT EXISTS (SELECT 1
4962: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
4963: WHERE hgi.geography_id = inter.geography_id
4964: AND hgi.IDENTIFIER_TYPE = 'NAME'
4965: AND hgi.IDENTIFIER_SUBTYPE = 'STANDARD_NAME'
4966: AND UPPER(hgi.IDENTIFIER_VALUE) = UPPER(inter.geography_name)