APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_GEOGRAPHY_IDENTIFIERS

Line 2063: INTO HZ_GEOGRAPHY_IDENTIFIERS

2059: fnd_global.user_id,
2060: sysdate,
2061: fnd_global.conc_login_id
2062: )
2063: INTO HZ_GEOGRAPHY_IDENTIFIERS
2064: (
2065: GEOGRAPHY_ID,
2066: GEO_DATA_PROVIDER,
2067: IDENTIFIER_SUBTYPE,

Line 2149: INTO HZ_GEOGRAPHY_IDENTIFIERS

2145: fnd_global.conc_login_id,
2146: p_tax_content_source
2147: )
2148: WHEN (action_type = 'UPDATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2149: INTO HZ_GEOGRAPHY_IDENTIFIERS
2150: (
2151: GEOGRAPHY_ID,
2152: GEO_DATA_PROVIDER,
2153: IDENTIFIER_SUBTYPE,

Line 2188: INTO HZ_GEOGRAPHY_IDENTIFIERS

2184: sysdate,
2185: fnd_global.conc_login_id
2186: )
2187: WHEN (action_type = 'UPDATE' AND geography_type IN ('COUNTY','CITY') AND geography_name IS NOT NULL) THEN
2188: INTO HZ_GEOGRAPHY_IDENTIFIERS
2189: (
2190: GEOGRAPHY_ID,
2191: GEO_DATA_PROVIDER,
2192: IDENTIFIER_SUBTYPE,

Line 2227: INTO HZ_GEOGRAPHY_IDENTIFIERS

2223: sysdate,
2224: fnd_global.conc_login_id
2225: )
2226: WHEN (action_type = 'CREATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2227: INTO HZ_GEOGRAPHY_IDENTIFIERS
2228: (
2229: GEOGRAPHY_ID,
2230: GEO_DATA_PROVIDER,
2231: IDENTIFIER_SUBTYPE,

Line 2265: INTO HZ_GEOGRAPHY_IDENTIFIERS

2261: fnd_global.user_id,
2262: sysdate,
2263: fnd_global.conc_login_id
2264: )
2265: INTO HZ_GEOGRAPHY_IDENTIFIERS
2266: (
2267: GEOGRAPHY_ID,
2268: GEO_DATA_PROVIDER,
2269: IDENTIFIER_SUBTYPE,

Line 2640: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi

2636: THEN
2637: 'CREATE'
2638: WHEN status = 'UPDATE' AND
2639: 'EXISTS' = (SELECT 'EXISTS'
2640: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
2641: WHERE hgi.geography_id = v.geography_id
2642: AND hgi.identifier_type = 'NAME'
2643: AND hgi.identifier_subtype = 'STANDARD_NAME'
2644: AND UPPER(hgi.identifier_value) = UPPER(DECODE(geography_type,'STATE',geography_name1,geography_name)))

Line 2937: INTO HZ_GEOGRAPHY_IDENTIFIERS

2933: fnd_global.user_id,
2934: sysdate,
2935: fnd_global.conc_login_id
2936: )
2937: INTO HZ_GEOGRAPHY_IDENTIFIERS
2938: (
2939: GEOGRAPHY_ID,
2940: GEO_DATA_PROVIDER,
2941: IDENTIFIER_SUBTYPE,

Line 2975: INTO HZ_GEOGRAPHY_IDENTIFIERS

2971: fnd_global.user_id,
2972: sysdate,
2973: fnd_global.conc_login_id
2974: )
2975: INTO HZ_GEOGRAPHY_IDENTIFIERS
2976: (
2977: GEOGRAPHY_ID,
2978: GEO_DATA_PROVIDER,
2979: IDENTIFIER_SUBTYPE,

Line 3919: INTO HZ_GEOGRAPHY_IDENTIFIERS

3915: fnd_global.user_id,
3916: sysdate,
3917: fnd_global.conc_login_id
3918: )
3919: INTO HZ_GEOGRAPHY_IDENTIFIERS
3920: (
3921: GEOGRAPHY_ID,
3922: GEO_DATA_PROVIDER,
3923: IDENTIFIER_SUBTYPE,

Line 3957: INTO HZ_GEOGRAPHY_IDENTIFIERS

3953: fnd_global.user_id,
3954: sysdate,
3955: fnd_global.conc_login_id
3956: )
3957: INTO HZ_GEOGRAPHY_IDENTIFIERS
3958: (
3959: GEOGRAPHY_ID,
3960: GEO_DATA_PROVIDER,
3961: IDENTIFIER_SUBTYPE,

Line 4538: INTO HZ_GEOGRAPHY_IDENTIFIERS

4534: WHILE (l_any_rows_to_process)
4535: LOOP**/
4536:
4537: INSERT ALL
4538: INTO HZ_GEOGRAPHY_IDENTIFIERS
4539: (
4540: GEOGRAPHY_ID,
4541: GEO_DATA_PROVIDER,
4542: IDENTIFIER_SUBTYPE,

Line 4584: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi

4580: WHERE inter.record_type = 07
4581: AND inter.last_updation_version > p_last_run_version
4582: AND inter.geography_id IS NOT NULL
4583: AND NOT EXISTS (SELECT 1
4584: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
4585: WHERE hgi.geography_id = inter.geography_id
4586: AND hgi.IDENTIFIER_TYPE = 'NAME'
4587: AND hgi.IDENTIFIER_SUBTYPE = 'STANDARD_NAME'
4588: AND UPPER(hgi.IDENTIFIER_VALUE) = UPPER(inter.geography_name)