[Home] [Help]
2013: WHERE idt.ledger_display_code = flb.ledger_display_code
2014: AND personal_flag = 'N'
2015: AND enabled_flag = 'Y'),
2016: dataset_code = (SELECT dataset_code
2017: FROM fem_datasets_b fdb
2018: WHERE idt.dataset_display_code = fdb.dataset_display_code
2019: AND personal_flag = 'N'
2020: AND enabled_flag = 'Y'),
2021: source_system_code = (SELECT source_system_code
2229: WHERE idt.ledger_display_code = flb.ledger_display_code
2230: AND personal_flag = 'N'
2231: AND enabled_flag = 'Y'),
2232: dataset_display_code = (SELECT dataset_display_code
2233: FROM fem_datasets_b fdb
2234: WHERE idt.dataset_code = fdb.dataset_code
2235: AND personal_flag = 'N'
2236: AND enabled_flag = 'Y'),
2237: (dimension_group_id,time_dimension_group_key) = (SELECT dimension_group_id, time_dimension_group_key
3308: gs_ds_code_tab(i) := all_str;
3309: ELSE
3310: SELECT dataset_display_code
3311: INTO gs_ds_code_tab(i)
3312: FROM fem_datasets_b
3313: WHERE dataset_code = gs_ds_tab(i)
3314: AND personal_flag = 'N'
3315: AND enabled_flag = 'Y';
3316: END IF;
3316: END IF;
3317: ELSE
3318: SELECT dataset_display_code
3319: INTO gs_ds_code_tab(i)
3320: FROM fem_datasets_b
3321: WHERE dataset_code = gs_ds_tab(i)
3322: AND personal_flag = 'N'
3323: AND enabled_flag = 'Y';
3324: