104: fem_entities_tl fet_counter,
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
292: FROM fem_entities_tl fet_cons,
293: gcs_hierarchies_tl ght,
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
412: FROM fem_entities_tl fet_cons,
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