DBA Data[Home] [Help]

APPS.PFT_PROFCAL_PROSP_IDENT_PUB dependencies on FEM_GLOBAL_VS_COMBO_DEFS

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