APPS.PFT_PROFCAL_VALIDX_PUB dependencies on FEM_DIMENSIONS_B

Line 409: fem_dimensions_b dim

405: BEGIN
406: SELECT gvsc.value_set_id
407: INTO l_value_set_id
408: FROM fem_global_vs_combo_defs gvsc,
409: fem_dimensions_b dim
410: WHERE gvsc.dimension_id = dim.dimension_id
411: AND dim.dimension_varchar_label = 'CUSTOMER'
412: AND gvsc.global_vs_combo_id = l_gvsc_id;
413: EXCEPTION

Line 715: fem_dimensions_b xdim,

711: SELECT dim_attr.attribute_id,ver.version_id
712: INTO l_attribute_id
713: ,l_version_id
714: FROM fem_dim_attributes_b dim_attr,
715: fem_dimensions_b xdim,
716: fem_dim_attr_versions_b ver
717: WHERE dim_attr.dimension_id = xdim.dimension_id
718: AND dim_attr.attribute_id = ver.attribute_id
719: AND dim_attr.attribute_varchar_label = 'REGION_CODE'

Line 990: fem_dimensions_b xdim,

986: ,ver.version_id
987: INTO l_attribute_id
988: ,l_version_id
989: FROM fem_dim_attributes_b dim_attr,
990: fem_dimensions_b xdim,
991: fem_dim_attr_versions_b ver
992: WHERE dim_attr.dimension_id = xdim.dimension_id
993: AND dim_attr.attribute_id = ver.attribute_id
994: AND dim_attr.attribute_varchar_label = 'PRODUCT_ID'