APPS.HRI_EDW_DIM_ORGANIZATION dependencies on HRI_PRIMARY_HRCHYS

Line 21: INSERT INTO hri_primary_hrchys (

17: WHERE organization_id = p_organization_id;
18: --
19: -- Fixed GSCC warning regarding explicit listing of columns in insert statements
20: --
21: INSERT INTO hri_primary_hrchys (
22: organization_structure_id
23: ,org_structure_version_id
24: ,organization_id
25: ,parent_organization_id

Line 113: DELETE FROM hri_primary_hrchys;

109:
110: BEGIN
111:
112: /* Clear out table */
113: DELETE FROM hri_primary_hrchys;
114:
115: /* Loop through each primary hierarchy */
116: FOR hierarchy_rec IN top_org_csr LOOP
117: