713: fb.xtd_balance_f + nvl(sum(nvl(fb_in.xtd_balance_f,0)),0)
714: FROM FEM_BALANCES fb_in,
715: FEM_CAL_PERIODS_B cp_curr,
716: FEM_CAL_PERIODS_B cp_prev,
717: FEM_CAL_PERIODS_ATTR cpa_curr,
718: FEM_CAL_PERIODS_ATTR cpa_prev,
719: FEM_CAL_PERIODS_ATTR cpa_curr_year,
720: FEM_CAL_PERIODS_ATTR cpa_prev_year,
721: GL_PERIODS per_curr,
714: FROM FEM_BALANCES fb_in,
715: FEM_CAL_PERIODS_B cp_curr,
716: FEM_CAL_PERIODS_B cp_prev,
717: FEM_CAL_PERIODS_ATTR cpa_curr,
718: FEM_CAL_PERIODS_ATTR cpa_prev,
719: FEM_CAL_PERIODS_ATTR cpa_curr_year,
720: FEM_CAL_PERIODS_ATTR cpa_prev_year,
721: GL_PERIODS per_curr,
722: GL_PERIODS per_prev
715: FEM_CAL_PERIODS_B cp_curr,
716: FEM_CAL_PERIODS_B cp_prev,
717: FEM_CAL_PERIODS_ATTR cpa_curr,
718: FEM_CAL_PERIODS_ATTR cpa_prev,
719: FEM_CAL_PERIODS_ATTR cpa_curr_year,
720: FEM_CAL_PERIODS_ATTR cpa_prev_year,
721: GL_PERIODS per_curr,
722: GL_PERIODS per_prev
723: WHERE fb_in.dataset_code = fb.dataset_code
716: FEM_CAL_PERIODS_B cp_prev,
717: FEM_CAL_PERIODS_ATTR cpa_curr,
718: FEM_CAL_PERIODS_ATTR cpa_prev,
719: FEM_CAL_PERIODS_ATTR cpa_curr_year,
720: FEM_CAL_PERIODS_ATTR cpa_prev_year,
721: GL_PERIODS per_curr,
722: GL_PERIODS per_prev
723: WHERE fb_in.dataset_code = fb.dataset_code
724: AND fb_in.source_system_code = fb.source_system_code