APPS.ZPB_BUSAREA_MAINT dependencies on FEM_FUNC_DIM_SETS_B

Line 1957: FEM_FUNC_DIM_SETS_B FDR_SET,

1953:
1954: CURSOR c_get_frd_ledgers IS
1955: select distinct DATA_LOC.LEDGER_ID
1956: from FEM_FUNC_DIM_SET_MAPS FDR_MAP,
1957: FEM_FUNC_DIM_SETS_B FDR_SET,
1958: FEM_DATA_LOCATIONS DATA_LOC,
1959: FEM_OBJECT_CATALOG_B OBJ,
1960: FEM_OBJECT_DEFINITION_B OBJ_DEF,
1961: FEM_LEDGERS_ATTR LEDGER_ATTR

Line 2021: from FEM_FUNC_DIM_SETS_B

2017: l_invalid_dim_list VARCHAR2(500);
2018:
2019: CURSOR c_get_fdr_dims IS
2020: select FUNC_DIM_SET_ID, DIMENSION_ID
2021: from FEM_FUNC_DIM_SETS_B
2022: where FUNC_DIM_SET_OBJ_DEF_ID = p_fdr_obj_def_id;
2023:
2024: CURSOR c_get_invalid_dims IS
2025: select A.FUNC_DIM_SET_ID, A.DIMENSION_ID, A.FUNC_DIM_SET_NAME, B.DESCRIPTION

Line 2073: from FEM_FUNC_DIM_SETS_B

2069: l_dimension_id);
2070: else
2071: select count(*)
2072: into l_count
2073: from FEM_FUNC_DIM_SETS_B
2074: where FUNC_DIM_SET_OBJ_DEF_ID = p_fdr_obj_def_id
2075: and DIMENSION_ID = l_dimension_id;
2076:
2077: if (l_count > 1) then

Line 2123: FEM_FUNC_DIM_SETS_B FDR_SET,

2119:
2120: CURSOR c_get_frd_datasets IS
2121: select distinct DATA_LOC.DATASET_CODE
2122: from FEM_FUNC_DIM_SET_MAPS FDR_MAP,
2123: FEM_FUNC_DIM_SETS_B FDR_SET,
2124: FEM_DATA_LOCATIONS DATA_LOC
2125: where FDR_MAP.FUNC_DIM_SET_ID = FDR_SET.FUNC_DIM_SET_ID
2126: and FDR_SET.FUNC_DIM_SET_OBJ_DEF_ID = p_fdr_obj_def_id
2127: and DATA_LOC.TABLE_NAME = FDR_MAP.TABLE_NAME