APPS.GCS_FEM_HIER_SYNC_PKG dependencies on FEM_HIERARCHIES

Line 95: INSERT INTO fem_hierarchies_t

91: l_hierarchy_name := substr(l_hierarchy_name, 1, 110) || ' effective since ' || l_start_date;
92:
93: -- Step 1: insert hierarchy header info
94:
95: INSERT INTO fem_hierarchies_t
96: ( hierarchy_object_name,
97: folder_name,
98: language,
99: dimension_varchar_label,

Line 334: fem_hierarchies fh

330:
331: SELECT fodb.object_definition_id
332: INTO l_object_definition_id
333: FROM fem_object_definition_vl fodb,
334: fem_hierarchies fh
335: WHERE fh.hierarchy_obj_id = fodb.object_id
336: AND fh.dimension_id = 18
337: AND fodb.display_name like l_hierarchy_name || '%'
338: AND l_start_date between fodb.effective_start_date and fodb.effective_end_date