APPS.GCS_XML_DT_UTILITY_PKG dependencies on FEM_DATASETS_ATTR

Line 615: fem_datasets_attr fda,

611: l_ledger_id
612: FROM gcs_data_type_codes_vl gdtcb,
613: gcs_entities_attr gea,
614: fem_ledgers_attr fla,
615: fem_datasets_attr fda,
616: fem_cal_periods_attr fcpa
617: WHERE gea.data_type_code = gdtcb.data_type_code
618: AND fla.ledger_id = gea.ledger_id
619: AND fda.dataset_code = gdtcb.source_dataset_code

Line 661: From each dataset code (fem_datasets_attr), you can get the

657: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_source_datasetcode : '||l_source_datasetcode);
658: END IF;
659:
660: /*
661: From each dataset code (fem_datasets_attr), you can get the
662: balance type (actual, budget, or encumbrance), and the
663: budget_version_id or encumbrance_type_id, if applicable.
664: */
665:

Line 671: FROM fem_datasets_attr fda

667: IF(l_dataset_code='BUDGET') THEN
668:
669: SELECT fda.dim_attribute_numeric_member
670: INTO l_budget_vers_id
671: FROM fem_datasets_attr fda
672: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').attribute_id
673: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').version_id
674: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
675:

Line 686: FROM fem_datasets_attr fda

682: IF(l_dataset_code='ENCUMBRANCE') THEN
683:
684: SELECT fda.dim_attribute_numeric_member
685: INTO l_enc_type_id
686: FROM fem_datasets_attr fda
687: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').attribute_id
688: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').version_id
689: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
690: