APPS.PFT_PROFCAL_PROSP_IDENT_PUB dependencies on FEM_DIMENSIONS_B

Line 218: FROM fem_global_vs_combo_defs gvsc,fem_dimensions_b dim

214: ,p_msg_text => 'Getting Customer Value Set Id');
215: BEGIN
216: SELECT gvsc.value_set_id
217: INTO l_value_set_id
218: FROM fem_global_vs_combo_defs gvsc,fem_dimensions_b dim
219: WHERE gvsc.dimension_id = dim.dimension_id
220: AND dim.dimension_varchar_label = 'CUSTOMER'
221: AND gvsc.global_vs_combo_id = l_gvsc_id;
222: EXCEPTION

Line 781: ' FEM_DIMENSIONS_B xdim '||

777: ' AND attr.ATTRIBUTE_ID = ( '||
778: ' SELECT att.ATTRIBUTE_ID '||
779: ' FROM FEM_CUSTOMERS_ATTR att, '||
780: ' FEM_DIM_ATTRIBUTES_B dim, '||
781: ' FEM_DIMENSIONS_B xdim '||
782: ' WHERE att.ATTRIBUTE_ID = dim.ATTRIBUTE_ID '||
783: ' AND dim.dimension_id = xdim.dimension_id '||
784: ' AND dim.ATTRIBUTE_VARCHAR_LABEL =
785: ''FEM_PROSPECT_IDENT''' ||