[Home] [Help]
64: BULK COLLECT INTO
65: l_dimension_vs_id
66: FROM fem_global_vs_combo_defs gvcd,
67: fem_ledgers_attr fla,
68: gcs_entities_attr gea,
69: fem_tab_column_prop ftcp,
70: fem_tab_columns_b ftcb,
71: gcs_data_sub_dtls gdsd,
72: fem_cal_periods_attr fcpa
344: l_source_system_code,
345: l_entity_currency_code,
346: l_entity_id
347: FROM gcs_data_sub_dtls gdsd,
348: gcs_entities_attr gea,
349: fem_ledgers_attr fla_comp,
350: fem_cal_periods_attr fcpa
351: WHERE gdsd.load_id = pXmlFileId
352: AND gea.entity_id = gdsd.entity_id
432: SELECT decode(gvcd.value_set_id, fch_gvcd.value_set_id, 'MAPPED', 'UNMAPPED')
433: INTO l_map_flag
434: FROM fem_global_vs_combo_defs gvcd,
435: fem_ledgers_attr fla,
436: gcs_entities_attr gea,
437: fem_tab_column_prop ftcp,
438: fem_tab_columns_b ftcb,
439: gcs_system_options gso,
440: fem_global_vs_combo_defs fch_gvcd,
609: INTO l_currency_code,
610: l_dataset_code,
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
638: -- Bugfix 5843592, Get the correct source data set code, depending upon the calendar period
639:
640: SELECT fibrd.actual_output_dataset_code
641: INTO l_source_datasetcode
642: FROM gcs_entities_attr gea ,
643: fem_object_definition_b fodb,
644: fem_intg_bal_rule_defs fibrd,
645: fem_cal_periods_attr fcpa
646: WHERE fodb.object_id = gea.balances_rule_id
770: l_fch_vsid,
771: l_map_flag
772: FROM fem_global_vs_combo_defs gvcd,
773: fem_ledgers_attr fla,
774: gcs_entities_attr gea,
775: gcs_system_options gso,
776: fem_global_vs_combo_defs fch_gvcd,
777: gcs_data_sub_dtls gdsd,
778: fem_cal_periods_attr fcpa