APPS.ZPB_BUSAREA_VAL dependencies on ZPB_BUSAREA_LEVELS

Line 556: from ZPB_BUSAREA_LEVELS A

552: cursor c_levels is
553: select A.LEVEL_ID,
554: A.HIERARCHY_ID,
555: A.LOGICAL_DIM_ID
556: from ZPB_BUSAREA_LEVELS A
557: where A.VERSION_ID = p_version_id
558: and A.LEVEL_ID not in
559: (select B.DIMENSION_GROUP_ID
560: from FEM_DIMENSION_GRPS_B B,

Line 885: select name from ZPB_BUSAREA_LEVELS_VL

881: and D.GLOBAL_VS_COMBO_ID = l_vs_combo_id;
882:
883:
884: cursor c_levels is
885: select name from ZPB_BUSAREA_LEVELS_VL
886: where version_id = p_version_id
887: order by logical_dim_id, hierarchy_id;
888:
889: cursor c_hiers is

Line 3006: ZPB_BUSAREA_LEVELS B,

3002: A.DIMENSION_ID FEM_DIMENSION_ID,
3003: C.LOGICAL_DIM_ID,
3004: nvl(C.FUNC_DIM_SET_ID, -99) AS FUNC_DIM_SET_ID
3005: from FEM_DIMENSION_GRPS_VL A,
3006: ZPB_BUSAREA_LEVELS B,
3007: ZPB_BUSAREA_DIMENSIONS C
3008: where A.DIMENSION_GROUP_ID = B.LEVEL_ID
3009: and B.VERSION_ID = l_refr_vers
3010: and C.VERSION_ID = l_refr_vers

Line 3015: from ZPB_BUSAREA_LEVELS C

3011: and C.LOGICAL_DIM_ID = B.LOGICAL_DIM_ID
3012: and C.DIMENSION_ID = A.DIMENSION_ID
3013: and B.LEVEL_ID not in
3014: (select C.LEVEL_ID
3015: from ZPB_BUSAREA_LEVELS C
3016: where C.VERSION_ID = p_version_id);
3017:
3018: cursor l_datasets is
3019: select A.DATASET_ID, A.NAME