APPS.PFT_PROFCAL_RGNCNT_PUB dependencies on FEM_DIMENSIONS_B

Line 255: FROM fem_global_vs_combo_defs gvsc,fem_dimensions_b dim

251:
252: BEGIN
253: SELECT gvsc.value_set_id
254: INTO l_value_set_id
255: FROM fem_global_vs_combo_defs gvsc,fem_dimensions_b dim
256: WHERE gvsc.dimension_id = dim.dimension_id
257: AND dim.dimension_varchar_label = 'CUSTOMER'
258: AND gvsc.global_vs_combo_id = l_gvsc_id;
259: EXCEPTION

Line 346: FROM fem_dim_attributes_b dim_attr,fem_dimensions_b xdim

342:
343: -- Get the attribute id for the region code attribute
344: SELECT dim_attr.attribute_id
345: INTO l_attribute_id
346: FROM fem_dim_attributes_b dim_attr,fem_dimensions_b xdim
347: WHERE dim_attr.dimension_id = xdim.dimension_id
348: AND dim_attr.attribute_varchar_label = 'REGION_CODE'
349: AND xdim.dimension_varchar_label = 'CUSTOMER';
350:

Line 945: ' fem_dimensions_b xdim ' ||

941: l_from_stmt := ' FROM ' ||
942: ' FEM_CUSTOMERS_ATTR fca , ' ||
943: ' (' || ' SELECT dim_attr.attribute_id ' ||
944: ' FROM fem_dim_attributes_b dim_attr, ' ||
945: ' fem_dimensions_b xdim ' ||
946: ' WHERE dim_attr.dimension_id = xdim.dimension_id'||
947: ' AND dim_attr.attribute_varchar_label = ' ||
948: '''REGION_CODE''' ||
949: ' AND xdim.dimension_varchar_label = ''CUSTOMER'''||