DBA Data[Home] [Help]

APPS.GCS_HIERARCHIES_PKG dependencies on GCS_DATA_TYPE_CODES_TL

Line 2233: gcs_data_type_codes_tl gdtctl,

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
2237: WHERE gdtcb.source_dataset_code = fda.dataset_code

Line 2435: gcs_data_type_codes_tl gdtctl,

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
2439: WHERE gdtcb.source_dataset_code = fda.dataset_code

Line 2626: gcs_data_type_codes_tl gtl

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
2630: AND gtl.language = userenv('LANG');