APPS.PFT_PROFCAL_RGNCNT_PUB dependencies on FEM_DIM_ATTRIBUTES_B

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 944: ' FROM fem_dim_attributes_b dim_attr, ' ||

940:
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''' ||