[Home] [Help]
105: gcs_hierarchies_tl ght,
106: gcs_cons_eng_runs gcer,
107: gcs_data_type_codes_b gdtcb,
108: gcs_data_type_codes_tl gdtct,
109: fem_cal_periods_tl fcpt,
110: --fem_entities_attr fea_cons,
111: fem_entities_attr fea_child
112: WHERE gcerd.run_detail_id = p_cons_detail_id
113: AND gcerd.consolidation_entity_id = fet_cons.entity_id
294: gcs_cons_eng_runs gcer,
295: gcs_data_type_codes_b gdtcb,
296: gcs_data_type_codes_tl gdtct,
297: fem_entities_attr fea_cons,
298: fem_cal_periods_tl fcpt
299: WHERE p_run_name = gcer.run_name
300: AND gcer.run_entity_id = p_cons_entity_id
301: AND gcer.run_entity_id = fet_cons.entity_id
302: AND gcer.hierarchy_id = ght.hierarchy_id
413: gcs_hierarchies_tl ght,
414: gcs_cons_eng_runs gcer,
415: gcs_data_type_codes_b gdtcb,
416: gcs_data_type_codes_tl gdtct,
417: fem_cal_periods_tl fcpt,
418: fem_entities_attr fea_cons
419: WHERE p_run_name = gcer.run_name
420: AND gcer.run_entity_id = p_cons_entity_id
421: AND gcer.run_entity_id = fet_cons.entity_id