DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_VAL dependencies on FEM_OBJECT_CATALOG_VL

Line 1416: from FEM_OBJECT_CATALOG_VL

1412:
1413: if (l_curr_vers = 'Y') then
1414: select OBJECT_NAME
1415: into l_hier_name
1416: from FEM_OBJECT_CATALOG_VL
1417: where OBJECT_ID = l_hier_id;
1418: else
1419: select DISPLAY_NAME
1420: into l_hier_name

Line 1471: from FEM_OBJECT_CATALOG_VL

1467:
1468: if (l_hier_vers_id is null) then
1469: select OBJECT_NAME
1470: into l_hier_name
1471: from FEM_OBJECT_CATALOG_VL
1472: where OBJECT_ID = l_hier_id;
1473: else
1474: select DISPLAY_NAME
1475: into l_hier_name

Line 2984: FEM_OBJECT_CATALOG_VL C,

2980: nvl(E.FUNC_DIM_SET_ID, -99) AS FUNC_DIM_SET_ID
2981: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES(l_ba_id,
2982: 'R')) A,
2983: FEM_HIERARCHIES D,
2984: FEM_OBJECT_CATALOG_VL C,
2985: ZPB_BUSAREA_DIMENSIONS E
2986: where A.HIERARCHY_ID = C.OBJECT_ID
2987: and A.HIERARCHY_ID = D.HIERARCHY_OBJ_ID
2988: and A.LOGICAL_DIM_ID = E.LOGICAL_DIM_ID