925: SELECT count(*)
926: INTO l_count_changed_dim
927: FROM (
928: (SELECT dimension_name
929: FROM zpb_cycle_model_dimensions
930: WHERE analysis_cycle_id = l_last_ac_id
931: MINUS
932: SELECT dimension_name
933: FROM zpb_cycle_model_dimensions
929: FROM zpb_cycle_model_dimensions
930: WHERE analysis_cycle_id = l_last_ac_id
931: MINUS
932: SELECT dimension_name
933: FROM zpb_cycle_model_dimensions
934: WHERE analysis_cycle_id = p_ac_id
935: )
936: UNION
937: (SELECT dimension_name
934: WHERE analysis_cycle_id = p_ac_id
935: )
936: UNION
937: (SELECT dimension_name
938: FROM zpb_cycle_model_dimensions
939: WHERE analysis_cycle_id = p_ac_id
940: MINUS
941: SELECT dimension_name
942: FROM zpb_cycle_model_dimensions
938: FROM zpb_cycle_model_dimensions
939: WHERE analysis_cycle_id = p_ac_id
940: MINUS
941: SELECT dimension_name
942: FROM zpb_cycle_model_dimensions
943: WHERE analysis_cycle_id = l_last_ac_id)
944: );
945:
946: /* IF (l_count_changed_dim = 0)THEN