DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_VAL dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 797: l_vs_combo_id FEM_GLOBAL_VS_COMBO_DEFS.GLOBAL_VS_COMBO_ID%type;

793: l_vers_type ZPB_BUSAREA_VERSIONS.VERSION_TYPE%type;
794: l_currency ZPB_BUSAREA_VERSIONS.CURRENCY_ENABLED%type;
795: l_intercompany ZPB_BUSAREA_VERSIONS.INTERCOMPANY_ENABLED%type;
796:
797: l_vs_combo_id FEM_GLOBAL_VS_COMBO_DEFS.GLOBAL_VS_COMBO_ID%type;
798:
799: l_owner_dim ZPB_DIMENSIONS.IS_OWNER_DIM%type;
800: l_def_hier ZPB_DIMENSIONS.DEFAULT_HIER%type;
801:

Line 873: FEM_GLOBAL_VS_COMBO_DEFS D

869: MINUS
870: select A.ATTRIBUTE_ID, A.VALUE, A.VALUE_SET_ID
871: from ZPB_BUSAREA_CONDITIONS_V A,
872: FEM_VALUE_SETS_B C,
873: FEM_GLOBAL_VS_COMBO_DEFS D
874: where A.VERSION_ID = p_version_id
875: and A.LOGICAL_DIM_ID = p_logical_dim_id
876: and A.VALUE_SET_ID is not null
877: and C.VALUE_SET_ID = A.VALUE_SET_ID