APPS.FII_FINANCIAL_DIMENSION_PKG dependencies on FII_DIM_NORM_HIERARCHY

Line 88: delete from fii_dim_norm_hierarchy

84:
85: -- delete cross-value set ranges if the parent_value_set_id is not
86: -- one of the dimension master value sets
87: /*
88: delete from fii_dim_norm_hierarchy
89: where child_flex_value_set_id <> parent_flex_value_set_id
90: and parent_flex_value_set_id not in
91: ( select master_value_set_id
92: from fii_financial_dimensions_v );

Line 94: DELETE /*+ index_ffs(fii_dim_norm_hierarchy) */

90: and parent_flex_value_set_id not in
91: ( select master_value_set_id
92: from fii_financial_dimensions_v );
93: */
94: DELETE /*+ index_ffs(fii_dim_norm_hierarchy) */
95: FROM fii_dim_norm_hierarchy
96: WHERE child_flex_value_set_id <> parent_flex_value_set_id
97: AND NOT EXISTS
98: (

Line 95: FROM fii_dim_norm_hierarchy

91: ( select master_value_set_id
92: from fii_financial_dimensions_v );
93: */
94: DELETE /*+ index_ffs(fii_dim_norm_hierarchy) */
95: FROM fii_dim_norm_hierarchy
96: WHERE child_flex_value_set_id <> parent_flex_value_set_id
97: AND NOT EXISTS
98: (
99: SELECT