APPS.ZPB_BUSAREA_VAL dependencies on FEM_OBJECT_DEFINITION_B

Line 549: from FEM_OBJECT_DEFINITION_B B

545: from ZPB_BUSAREA_HIER_VERSIONS A
546: where A.VERSION_ID = p_version_id
547: and A.HIER_VERSION_ID not in
548: (select B.OBJECT_DEFINITION_ID
549: from FEM_OBJECT_DEFINITION_B B
550: where A.HIERARCHY_ID = B.OBJECT_ID);
551:
552: cursor c_levels is
553: select A.LEVEL_ID,

Line 719: FEM_OBJECT_DEFINITION_B D,

715: and A.VERSION_ID = '||p_version_id||'
716: and A.MEMBER_ID not in
717: (select distinct C.CHILD_ID
718: from '||l_hier_table||' C,
719: FEM_OBJECT_DEFINITION_B D,
720: '||l_dim_table||' E
721: where C.HIERARCHY_OBJ_DEF_ID = D.OBJECT_DEFINITION_ID
722: and D.OBJECT_ID = A.HIERARCHY_ID
723: and D.OBJECT_DEFINITION_ID = nvl(A.HIER_VERSION_ID,

Line 939: from FEM_OBJECT_DEFINITION_B

935: for each_hier in c_hiers
936: loop
937: select count(*)
938: into l_count
939: from FEM_OBJECT_DEFINITION_B
940: where OBJECT_ID = each_hier.HIERARCHY_ID
941: and effective_start_date <= sysdate
942: and effective_end_date >= sysdate;
943: if (l_count = 0) then

Line 1060: fem_object_definition_b objdef,fem_object_catalog_b obj

1056: into l_count
1057: from ZPB_BUSAREA_LEDGERS B,
1058: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1059: FEM_DIM_ATTR_VERSIONS_B E,
1060: fem_object_definition_b objdef,fem_object_catalog_b obj
1061: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1062: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
1063: and E.DEFAULT_VERSION_FLAG = 'Y'
1064: and E.AW_SNAPSHOT_FLAG = 'N'