APPS.ZPB_BUSAREA_VAL dependencies on ZPB_BUSAREA_LEDGERS

Line 578: from ZPB_BUSAREA_LEDGERS A

574: where PERSONAL_FLAG = 'N');
575:
576: cursor c_ledgers is
577: select A.LEDGER_ID
578: from ZPB_BUSAREA_LEDGERS A
579: where A.VERSION_ID = p_version_id
580: and A.LEDGER_ID not in
581: (select LEDGER_ID
582: from FEM_LEDGERS_B

Line 674: delete from ZPB_BUSAREA_LEDGERS

670: --
671: for each in c_ledgers loop
672: REGISTER_ERROR('S', 'W', 'ZPB_BUSAREA_VAL_REMOVED',
673: 'OBJ_TYPE', 'ZPB_LEDGER', 'Y');
674: delete from ZPB_BUSAREA_LEDGERS
675: where VERSION_ID = p_version_id
676: and LEDGER_ID = each.LEDGER_ID;
677: end loop;
678:

Line 1014: from ZPB_BUSAREA_LEDGERS

1010: end if;
1011:
1012: select count(*)
1013: into l_count
1014: from ZPB_BUSAREA_LEDGERS
1015: where VERSION_ID = p_version_id;
1016: if (l_count = 0) then
1017: REGISTER_ERROR('S', 'E', 'ZPB_BUSAREA_VAL_MISSING',
1018: 'OBJ_TYPE', 'ZPB_LEDGER', 'Y');

Line 1043: from ZPB_BUSAREA_LEDGERS B,

1039:
1040: if (l_fdr_id = -99) then
1041: select count(distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER))
1042: into l_count
1043: from ZPB_BUSAREA_LEDGERS B,
1044: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1045: FEM_DIM_ATTR_VERSIONS_B E
1046: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1047: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID

Line 1057: from ZPB_BUSAREA_LEDGERS B,

1053: and B.VERSION_ID = p_version_id;
1054: else
1055: select count(distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER))
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'

Line 1170: from ZPB_BUSAREA_LEDGERS B,

1166: end if;
1167:
1168: select distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER)
1169: into l_vs_combo_id
1170: from ZPB_BUSAREA_LEDGERS B,
1171: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1172: FEM_DIM_ATTR_VERSIONS_B E
1173: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1174: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID