DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 627: FROM fem_xdim_dimensions fxd,

623: SELECT fxd.default_mvs_hierarchy_obj_id,
624: fodb.object_definition_id
625: INTO l_hier_obj_id,
626: l_hier_obj_definition_id
627: FROM fem_xdim_dimensions fxd,
628: fem_object_definition_b fodb
629: WHERE fxd.dimension_id = 8
630: AND fxd.default_mvs_hierarchy_obj_id = fodb.object_id
631: AND l_cal_period_end_date BETWEEN fodb.effective_start_date AND

Line 2813: FROM fem_xdim_dimensions fxd,

2809:
2810: BEGIN
2811: SELECT fodb.object_definition_id
2812: INTO l_hier_obj_definition_id
2813: FROM fem_xdim_dimensions fxd,
2814: fem_object_definition_b fodb
2815: WHERE fxd.dimension_id = 8
2816: AND fxd.default_mvs_hierarchy_obj_id = fodb.object_id
2817: AND l_cal_period_end_date BETWEEN fodb.effective_start_date AND