DBA Data[Home] [Help]

APPS.GCS_HIERARCHIES_PKG dependencies on GCS_DATA_TYPE_CODES_B

Line 2232: FROM gcs_data_type_codes_b gdtcb,

2228: SELECT gdtctl.data_type_name,
2229: gdtcb.source_dataset_code,
2230: fda.dim_attribute_varchar_member
2231: INTO l_data_type_name, l_dataset_code, l_fem_balance_type
2232: FROM gcs_data_type_codes_b gdtcb,
2233: gcs_data_type_codes_tl gdtctl,
2234: fem_dim_attributes_b fdab,
2235: fem_dim_attr_versions_b fdavb,
2236: fem_datasets_attr fda

Line 2434: FROM gcs_data_type_codes_b gdtcb,

2430: gdtctl.data_type_name,
2431: gdtcb.source_dataset_code,
2432: fda.dim_attribute_varchar_member BULK COLLECT
2433: INTO l_data_type_info
2434: FROM gcs_data_type_codes_b gdtcb,
2435: gcs_data_type_codes_tl gdtctl,
2436: fem_dim_attributes_b fdab,
2437: fem_dim_attr_versions_b fdavb,
2438: fem_datasets_attr fda

Line 2625: gcs_data_type_codes_b gtb,

2621: gdc.dataset_code,
2622: gtl.data_type_name BULK COLLECT
2623: INTO l_dataset_info
2624: FROM gcs_dataset_codes gdc,
2625: gcs_data_type_codes_b gtb,
2626: gcs_data_type_codes_tl gtl
2627: WHERE gdc.hierarchy_id = p_hierarchy_id
2628: AND INSTR(gdc.balance_type_code,gtb.data_type_code) > 0
2629: AND gtb.data_type_id = gtl.data_type_id