APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_HIERARCHY_NODES

Line 2391: INTO hz_hierarchy_nodes

2387: sysdate,
2388: fnd_global.conc_login_id
2389: )
2390: --Self
2391: INTO hz_hierarchy_nodes
2392: (
2393: HIERARCHY_TYPE,
2394: PARENT_ID,
2395: PARENT_TABLE_NAME,

Line 2710: INTO hz_hierarchy_nodes

2706: null,
2707: p_tax_content_source
2708: )
2709: --Immediate Parent
2710: INTO hz_hierarchy_nodes
2711: (
2712: HIERARCHY_TYPE,
2713: PARENT_ID,
2714: PARENT_TABLE_NAME,

Line 2757: INTO hz_hierarchy_nodes

2753: fnd_global.conc_login_id,
2754: p_tax_content_source
2755: )
2756: WHEN (action_type = 'CREATE' AND geography_type = 'COUNTY') THEN
2757: INTO hz_hierarchy_nodes
2758: (
2759: HIERARCHY_TYPE,
2760: PARENT_ID,
2761: PARENT_TABLE_NAME,

Line 2804: INTO hz_hierarchy_nodes

2800: fnd_global.conc_login_id,
2801: p_tax_content_source
2802: )
2803: WHEN (action_type = 'CREATE' AND geography_type = 'CITY') THEN
2804: INTO hz_hierarchy_nodes
2805: (
2806: HIERARCHY_TYPE,
2807: PARENT_ID,
2808: PARENT_TABLE_NAME,

Line 2850: INTO hz_hierarchy_nodes

2846: sysdate,
2847: fnd_global.conc_login_id,
2848: p_tax_content_source
2849: )
2850: INTO hz_hierarchy_nodes
2851: (
2852: HIERARCHY_TYPE,
2853: PARENT_ID,
2854: PARENT_TABLE_NAME,

Line 4478: INTO hz_hierarchy_nodes

4474: null,
4475: p_tax_content_source
4476: )
4477: --Self
4478: INTO hz_hierarchy_nodes
4479: (
4480: HIERARCHY_TYPE,
4481: PARENT_ID,
4482: PARENT_TABLE_NAME,

Line 4525: INTO hz_hierarchy_nodes

4521: fnd_global.conc_login_id,
4522: p_tax_content_source
4523: )
4524: -- City
4525: INTO hz_hierarchy_nodes
4526: (
4527: HIERARCHY_TYPE,
4528: PARENT_ID,
4529: PARENT_TABLE_NAME,

Line 4573: INTO hz_hierarchy_nodes

4569: p_tax_content_source
4570: )
4571: -- County
4572: WHEN (geography_element3_id IS NOT NULL) THEN
4573: INTO hz_hierarchy_nodes
4574: (
4575: HIERARCHY_TYPE,
4576: PARENT_ID,
4577: PARENT_TABLE_NAME,

Line 4620: INTO hz_hierarchy_nodes

4616: fnd_global.conc_login_id,
4617: p_tax_content_source
4618: )
4619: WHEN (geography_element2_id IS NOT NULL) THEN
4620: INTO hz_hierarchy_nodes
4621: (
4622: HIERARCHY_TYPE,
4623: PARENT_ID,
4624: PARENT_TABLE_NAME,

Line 4667: INTO hz_hierarchy_nodes

4663: fnd_global.conc_login_id,
4664: p_tax_content_source
4665: )
4666: WHEN (geography_element1_id IS NOT NULL) THEN
4667: INTO hz_hierarchy_nodes
4668: (
4669: HIERARCHY_TYPE,
4670: PARENT_ID,
4671: PARENT_TABLE_NAME,