2240: AND fda.attribute_id = fdab.attribute_id
2241: AND fdab.attribute_id = fdavb.attribute_id
2242: AND fda.version_id = fdavb.version_id
2243: AND fdavb.default_version_flag = 'Y'
2244: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
2245: AND gdtcb.data_type_code = p_data_type_code;
2246:
2247: -- If the source dataset is a budget or encumbrance, get the budget or encumbrance type id of the source dataset
2248: IF l_fem_balance_type = 'BUDGET' THEN
2254: WHERE fda.attribute_id = fdab.attribute_id
2255: AND fdab.attribute_id = fdavb.attribute_id
2256: AND fda.version_id = fdavb.version_id
2257: AND fdavb.default_version_flag = 'Y'
2258: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-BUDGET_ID')
2259: AND fda.dataset_code = l_dataset_code;
2260: END IF;
2261:
2262: IF l_fem_balance_type = 'ENCUMBRANCE' THEN
2268: WHERE fda.attribute_id = fdab.attribute_id
2269: AND fdab.attribute_id = fdavb.attribute_id
2270: AND fda.version_id = fdavb.version_id
2271: AND fdavb.default_version_flag = 'Y'
2272: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
2273: AND fda.dataset_code = l_dataset_code;
2274: END IF;
2275:
2276: l_base_balance_type := p_data_type_code;
2442: AND fda.attribute_id = fdab.attribute_id
2443: AND fdab.attribute_id = fdavb.attribute_id
2444: AND fda.version_id = fdavb.version_id
2445: AND fdavb.default_version_flag = 'Y'
2446: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-DATASET_BALANCE_TYPE_CODE');
2447:
2448: IF l_data_type_info.FIRST IS NOT NULL AND
2449: l_data_type_info.LAST IS NOT NULL THEN
2450: FOR l_counter IN l_data_type_info.FIRST .. l_data_type_info.LAST LOOP
2469: WHERE fda.attribute_id = fdab.attribute_id
2470: AND fdab.attribute_id = fdavb.attribute_id
2471: AND fda.version_id = fdavb.version_id
2472: AND fdavb.default_version_flag = 'Y'
2473: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-BUDGET_ID')
2474: AND fda.dataset_code = l_dataset_code;
2475: END IF;
2476:
2477: IF l_fem_balance_type = 'ENCUMBRANCE' THEN
2483: WHERE fda.attribute_id = fdab.attribute_id
2484: AND fdab.attribute_id = fdavb.attribute_id
2485: AND fda.version_id = fdavb.version_id
2486: AND fdavb.default_version_flag = 'Y'
2487: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
2488: AND fda.dataset_code = l_dataset_code;
2489: END IF;
2490:
2491: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');