APPS.ZPB_BUSAREA_VAL dependencies on FEM_DIM_ATTRIBUTES_VL

Line 803: l_attr_name FEM_DIM_ATTRIBUTES_VL.ATTRIBUTE_NAME%type;

799: l_owner_dim ZPB_DIMENSIONS.IS_OWNER_DIM%type;
800: l_def_hier ZPB_DIMENSIONS.DEFAULT_HIER%type;
801:
802: l_dim_name FEM_DIMENSIONS_VL.DIMENSION_NAME%type;
803: l_attr_name FEM_DIM_ATTRIBUTES_VL.ATTRIBUTE_NAME%type;
804:
805: l_hier_id NUMBER;
806: l_hier_vers_id NUMBER;
807: l_hier_name VARCHAR2(150);

Line 1701: from FEM_DIM_ATTRIBUTES_VL

1697: and FDR.FUNC_DIM_SET_ID (+) = B.FUNC_DIM_SET_ID ;
1698:
1699: select ATTRIBUTE_NAME
1700: into l_attr_name
1701: from FEM_DIM_ATTRIBUTES_VL
1702: where ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1703: and DIMENSION_ID = l_org_dim_id;
1704:
1705: REGISTER_ERROR('S', 'W', 'ZPB_BUSAREA_VAL_ORG_NOCURRATTR',

Line 1801: from FEM_DIM_ATTRIBUTES_VL

1797: and FDR.FUNC_DIM_SET_ID (+) = B.FUNC_DIM_SET_ID ;
1798:
1799: select ATTRIBUTE_NAME
1800: into l_attr_name
1801: from FEM_DIM_ATTRIBUTES_VL
1802: where ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1803: and DIMENSION_ID = l_org_dim_id;
1804:
1805: REGISTER_ERROR('S', 'W', 'ZPB_BUSAREA_VAL_ORG_NOCURRATTR',

Line 3034: FEM_DIM_ATTRIBUTES_VL C,

3030: C.DIMENSION_ID FEM_DIMENSION_ID,
3031: D.LOGICAL_DIM_ID,
3032: nvl(D.FUNC_DIM_SET_ID, -99) AS FUNC_DIM_SET_ID
3033: from ZPB_BUSAREA_ATTRIBUTES A,
3034: FEM_DIM_ATTRIBUTES_VL C,
3035: ZPB_BUSAREA_DIMENSIONS D
3036: where A.VERSION_ID = l_refr_vers
3037: and A.ATTRIBUTE_ID = C.ATTRIBUTE_ID
3038: and C.DIMENSION_ID = D.DIMENSION_ID