DBA Data[Home] [Help]

APPS.GCS_CREATE_LEVELS_PKG dependencies on FEM_DIMENSION_GRPS_B_T

Line 155: DELETE FROM fem_dimension_grps_b_t

151: FROM FEM_DIMENSIONS_B
152: WHERE dimension_varchar_label = p_dimension;
153:
154: -- Delete orphan records from the _T table
155: DELETE FROM fem_dimension_grps_b_t
156: WHERE dimension_varchar_label = p_dimension
157: AND dimension_group_display_code IN
158: ( SELECT dimension_group_display_code FROM GCS_EPB_LEVELS_GT );
159:

Line 166: INSERT INTO fem_dimension_grps_b_t

162: AND dimension_group_display_code IN
163: ( SELECT dimension_group_display_code FROM GCS_EPB_LEVELS_GT );
164:
165: -- Populate the dimension groups interface tables
166: INSERT INTO fem_dimension_grps_b_t
167: (dimension_group_display_code,
168: dimension_varchar_label,
169: dimension_group_seq,
170: status)