APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_HIERARCHY_NODES

Line 2102: INTO hz_hierarchy_nodes

2098: sysdate,
2099: fnd_global.conc_login_id
2100: )
2101: --Self
2102: INTO hz_hierarchy_nodes
2103: (
2104: HIERARCHY_TYPE,
2105: PARENT_ID,
2106: PARENT_TABLE_NAME,

Line 2421: INTO hz_hierarchy_nodes

2417: null,
2418: p_tax_content_source
2419: )
2420: --Immediate Parent
2421: INTO hz_hierarchy_nodes
2422: (
2423: HIERARCHY_TYPE,
2424: PARENT_ID,
2425: PARENT_TABLE_NAME,

Line 2468: INTO hz_hierarchy_nodes

2464: fnd_global.conc_login_id,
2465: p_tax_content_source
2466: )
2467: WHEN (action_type = 'CREATE' AND geography_type = 'COUNTY') THEN
2468: INTO hz_hierarchy_nodes
2469: (
2470: HIERARCHY_TYPE,
2471: PARENT_ID,
2472: PARENT_TABLE_NAME,

Line 2515: INTO hz_hierarchy_nodes

2511: fnd_global.conc_login_id,
2512: p_tax_content_source
2513: )
2514: WHEN (action_type = 'CREATE' AND geography_type = 'CITY') THEN
2515: INTO hz_hierarchy_nodes
2516: (
2517: HIERARCHY_TYPE,
2518: PARENT_ID,
2519: PARENT_TABLE_NAME,

Line 2561: INTO hz_hierarchy_nodes

2557: sysdate,
2558: fnd_global.conc_login_id,
2559: p_tax_content_source
2560: )
2561: INTO hz_hierarchy_nodes
2562: (
2563: HIERARCHY_TYPE,
2564: PARENT_ID,
2565: PARENT_TABLE_NAME,

Line 4112: INTO hz_hierarchy_nodes

4108: null,
4109: p_tax_content_source
4110: )
4111: --Self
4112: INTO hz_hierarchy_nodes
4113: (
4114: HIERARCHY_TYPE,
4115: PARENT_ID,
4116: PARENT_TABLE_NAME,

Line 4159: INTO hz_hierarchy_nodes

4155: fnd_global.conc_login_id,
4156: p_tax_content_source
4157: )
4158: -- City
4159: INTO hz_hierarchy_nodes
4160: (
4161: HIERARCHY_TYPE,
4162: PARENT_ID,
4163: PARENT_TABLE_NAME,

Line 4207: INTO hz_hierarchy_nodes

4203: p_tax_content_source
4204: )
4205: -- County
4206: WHEN (geography_element3_id IS NOT NULL) THEN
4207: INTO hz_hierarchy_nodes
4208: (
4209: HIERARCHY_TYPE,
4210: PARENT_ID,
4211: PARENT_TABLE_NAME,

Line 4254: INTO hz_hierarchy_nodes

4250: fnd_global.conc_login_id,
4251: p_tax_content_source
4252: )
4253: WHEN (geography_element2_id IS NOT NULL) THEN
4254: INTO hz_hierarchy_nodes
4255: (
4256: HIERARCHY_TYPE,
4257: PARENT_ID,
4258: PARENT_TABLE_NAME,

Line 4301: INTO hz_hierarchy_nodes

4297: fnd_global.conc_login_id,
4298: p_tax_content_source
4299: )
4300: WHEN (geography_element1_id IS NOT NULL) THEN
4301: INTO hz_hierarchy_nodes
4302: (
4303: HIERARCHY_TYPE,
4304: PARENT_ID,
4305: PARENT_TABLE_NAME,